The MERGE pattern that cost ten times more than INSERT-then-UPDATE — a ₹100 Cr lesson
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.