Articles in this series
Here’s a quick BigQuery SQL exercise. I often work with cumulative aggregations, but it’s not every day that I need to reverse them—converting...
Ever needed to track what changed in a table and when? In data engineering, this is known as Change Data Capture (CDC)—a fundamental challenge when...
When we talk about functions in BigQuery, we're referring to several distinct capabilities. Beyond the standard built-in functions like...
In yesterday’s post, we looked at retrieving information from a table by joining it multiple times—each with different join criteria. This raises a...
Ever had a random piece of knowledge from school suddenly click in a real-world scenario? It felt like that for me remembering about ROLLUP a few days...
A few days ago I thought that the following SQL query would not work— I expected the window function result would be summed multiple times. 🚨 Turns...
