Subscribe to continue reading
Become a paid subscriber to get access to the rest of this post and other exclusive content.
Subscribe to My Newsletter
Subscribe to my email newsletter to get the latest posts delivered right to your email. Pure inspiration, zero spam.
Recommended for You
User-Defined Functions in BigQuery
Stop pasting the same logic into every query. Learn user-defined functions in BigQuery: SQL and JavaScript UDFs, temporary versus persistent scope, parameters, JSON parsing, and when to use each.
BigQuery Correlated Subqueries: 10 Code-Along Examples
Learn BigQuery correlated subqueries by running them. Ten copy-and-run examples with sample tables covering EXISTS, NOT EXISTS, subqueries in SELECT and WHERE, per-group comparisons, lifetime-value thresholds, and rewriting as a JOIN.