Writing
Technical write-ups on data engineering, mostly BigQuery and SQL.
January 2025
Tired of stacking UNION ALL, have you tried BigQuery GROUPING SETS?
This article explores BigQuery's GROUPING SETS clause as a more concise and readable alternative to complex UNION ALL queries for generating aggregations at multiple levels of granularity.
- bigquery
- sql
- data-engineer
- data-analysis
January 2025
BigQuery “NOT IN” vs “NOT EXISTS” vs “EXCEPT DISTINCT” understand the differences in 3 minutes!
This article compares three BigQuery operators—NOT IN, NOT EXISTS, and EXCEPT DISTINCT—for excluding data from query results, using a real-world debugging scenario involving bot traffic exclusion.
- bigquery
- sql
- data-engineer