DATALAD ™
DATALAD ™
What are You Looking For?
Trending Now
DATALAD ™
DATALAD ™
Search
Contact me
DATALAD ™
DATALAD ™
Andrei's avatarAndrei
October 25, 2026
1 min read
2

BigQuery CTEs Cheatsheet

A one-page BigQuery CTE reference, every snippet explained line by line: WITH syntax, subquery refactoring, chaining, multiple references, top-N per group, dashboard pre-aggregation, and CTEs versus temp tables and views.

A common table expression is a named, temporary result set defined with WITH, turning inside-out subqueries into top-to-bottom pipelines you can read like a recipe. This cheatsheet gathers every pattern on one page, each snippet annotated line by line. Keep it open while you query, or save the image and pin it nearby.

For the full background, read the guide to common table expressions in BigQuery.

Download the cheatsheet

cteDownload

Hope this helps, Andrei.

Andrei's avatarAndrei
October 25, 2026
1 min read
2
View Comments (2)

Leave a Reply

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

BigQuery Materialized Views Cheatsheet

A one-page BigQuery materialized views reference, every snippet explained line by line: creation, smart tuning, the dashboard pattern, refresh and staleness options, partitioning, metadata inspection, and non-incremental views.
October 25, 2026
1 min read

Transformer Models with PyTorch Cheatsheet

A one-page PyTorch transformer reference, every snippet explained line by line: token embeddings, positional encoding, scaled dot-product and multi-head attention, the causal mask, feed-forward blocks, the encoder, task heads, and nn.Transformer.
October 25, 2026
1 min read