William Wibowo - Homepage

Loading...

This This

is is

my my

Blog Blog

Here Here

are are

some some

of of

my my

recorded recorded

thoughts. thoughts.

Tired of stacking UNION ALL, have you tried BigQuery GROUPING SETS?
(January 2025)
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.
1. #bigquery
2. #sql
3. #data-engineer
4. #data-analysis
BigQuery “NOT IN” vs “NOT EXISTS” vs “EXCEPT DISTINCT” understand the differences in 3 minutes!
(January 2025)
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.
1. #bigquery
2. #sql
3. #data-engineer