SQL remains the primary interface for analytical queries in data warehouse environments. Articles cover BigQuery SQL optimisation, Gemini-powered SQL generation, and the query patterns that reduce both execution time and compute cost in large-scale analytical workloads.
1 post tagged with sql. ← All posts
What looked like an idiomatic BigQuery MERGE was scanning the full target table on every batch. The fix was syntactic, not architectural — and it was the single biggest contributor to a 57% data-warehouse cost reduction across the Tata Group engagement.
All posts on this site are written by Pratik Dhanave, an Agentic AI Architect with 7+ years building production distributed systems, multi-agent AI platforms, and cloud-native infrastructure. About the author → Each article includes working code, architecture diagrams, and references to the specific frameworks and standards discussed. Browse all posts or explore related topics using the tag cloud above.