· intermediate
Transformations with dbt
Treating SQL like software. Models that reference each other, a dependency graph you did not have to draw, tests that run before anyone sees the numbers, and incremental models that do not quietly drift.
Written in house, from the work rather than from a syllabus. Every example is one we would use ourselves, and every quiz question explains why its answer is right.
What you’ll learn
- Write a model and reference another so dbt infers the dependency graph
- Separate sources, staging and marts, and say why each exists
- Add tests that fail a build before wrong numbers reach a dashboard
- Choose a materialisation from how the model is queried
- Write an incremental model that reprocesses late data correctly
- Say what dbt does not do, and what still needs an orchestrator
Before you start
- · Intermediate SQL
- · Data Warehousing, or equivalent