About Me

👋 About Me

Hi, I'm Ravin — data engineer by day, storyteller by soul, and accidental cat wrangler. By profession I work hands-on with SQL, BigQuery, and cloud data pipelines; by nature I'm someone who can't resist writing about life's technical triumphs and cultural joys from my corner of Malaysia.

This blog, Scripts & Serendipity, started as a personal journal and has grown into two things at once: a practical, tested resource for SQL and data engineering tutorials, and a personal space for the food, culture, and serendipitous cat chaos that make up the rest of my life.

If you're here for a solid SQL trick or a BigQuery deep-dive, you'll find real, tested examples from my day-to-day work — no fluff, no copy-pasted syntax I haven't actually run myself. If you stuck around for a warm bowl of sambal or unexpected cat chaos, well — you're in the right place too.

📹 Featured Video

© 2025 Ravin | All thoughts proudly caffeinated ☕

Contact Me | Home

Comments

Post a Comment

Popular Posts

BigQuery MERGE Statement – Explained

Image
BigQuery MERGE Statement – Explained with Syntax & Use Cases BigQuery MERGE Statement – Explained 📘 What is BigQuery MERGE? The MERGE statement in BigQuery allows you to conditionally INSERT , UPDATE , or DELETE rows in a target table based on matching rows from a source table. It’s ideal for data synchronization, staging table merges, and incremental updates. 🖼️ Thumbnail Preview 🧪 Syntax Overview MERGE target_table AS T USING source_table AS S ON T.id = S.id WHEN MATCHED THEN UPDATE SET T.name = S.name WHEN NOT MATCHED THEN INSERT (id, name) VALUES (S.id, S.name); 🎯 Example Use Case MERGE dataset.inventory AS I USING dataset.new_arrivals AS N ON I.product_id = N.product_id WHEN MATCHED THEN UPDATE SET I.quantity = I.quantity + N...
Read more

LRT Masjid Jamek-Bandaraya

Image
LRT Ampang Line Closure – Masjid Jamek to Bandaraya Suspension Update LRT Ampang Line Update – Service Suspension Extended The section of the LRT Ampang Line between Masjid Jamek and Bandaraya stations will remain closed for an additional two weeks following the discovery of significant structural damage on an overhead viaduct near Bandaraya. Transport Minister Anthony Loke stated that the line will reopen only after corrective measures and safety assessments are fully completed. “Once it is okay and safety is ensured, we will reopen the line. I apologise to all commuters who are affected,” he added. Public transport operator Rapid Rail has engaged a professional engineering firm to conduct a detailed investigation of the cracked viaduct and pier. This probe will help determine the source of damage and inform the restoration strategy. 🚍 S...
Read more

Spicy Prawn Masala | Prawn Masala Curry Recipe | Shrimp Masala

Spicy Prawn Masala Recipe 🌶️ Introduction: A Fiery Seafood Favourite Craving something bold and brimming with spice? This Spicy Prawn Masala is a soul-satisfying dish that brings the heat and heart of South Indian kitchens right to your table. Inspired by weekend market hauls and cherished family memories, it’s the kind of recipe that turns ordinary prawns into a culinary celebration. Whether paired with fluffy basmati rice or soft naan, this dish is bound to impress seafood lovers and spice enthusiasts alike. 🧄 Ingredients 500g fresh prawns, cleaned and deveined 2 medium onions, finely chopped 2 tomatoes, pureed 1 tbsp ginger-garlic paste 2 green chillies, slit 1 tsp turmeric powder 1½ tsp red chilli powder 1 tsp coriander powder ½ tsp garam masala Salt to taste Fresh coriander leaves for garnish 2 tbsp oil 🍳 Preparation Heat oil in a pan and sauté the onion...
Read more