01 · Field guide
The Modern Cloud Warehouse Modeling Guide
A field guide to trustworthy analytical SQL models.
Learn how to reason about grain, fan-outs, SCD2 joins, window-function grain shifts, nested data explosions, deduplication, incremental drift, tests, and review contracts. Includes an offline HTML reader, BigQuery exercises, practice questions, expected outputs, and bonus review tools.