← Previous · Film 5 of 10
Promises and proofs
Every gap gets a decision. Promise it in a contract; prove it with a test, written before the code it checks.
Topics › Analytics engineering › In the weeds of data crafting
Built in layers: one job per layer, one step per CTE
The tests are written, and they wait for code. Like the stations of Escoffier's kitchen, each layer of Jun's project does one job: staging tidies a table, intermediate holds the steps, the core holds what the blueprint names, and each mart serves one consumer. Inside a model, each CTE is one step.
Builds on Promises and proofs
Watch the film
Press Play, or pick a chapter. Turn on Pause and think to stop for one question at the end of chapters.
Download the videoCaption filesRead the script
Where next?
You've seen each layer do its job. Now put each piece where it belongs.
See it in the project
Every card in the film shows a real file from the example dbt project. Open the ones each chapter shows, on GitHub, or run the whole project yourself.
- Staging
skills/draft-a-model/SKILL.mdmodels/staging/short_courses/stg_short_courses__learners.sqldocs/conventions.md - Intermediate
docs/conventions.mdmodels/intermediate/student/int_learner_timeline.sql - Core
dbt_project.ymlmodels/core/course/core_award.sql - Marts
models/marts/wallet/_wallet__models.yml - One CTE, one step
models/marts/planning/mart_planning__near_award.sqldocs/conventions.md - Physical choices
dbt_project.ymlmodels/core/student/core_credential_v2.sql - Metrics once
macros/planning/near_award.sqldbt_project.ymlmodels/marts/planning/_planning__semantic.yml
Think it through
The four Pause and think questions, for a class or a team. Open one to see the answer.
In the series: In the weeds of data crafting
Film 6 of 10.
Next · Film 7 of 10 →
Who owns what
Each fact's meaning has an owner. Owners publish a public, versioned core; consumers build on it, never on each other's marts.