← Previous · Film 9 of 10
Written once
Every copy of a fact is a chance to drift. One home per fact, everything else generated, and a breaking change arrives as a new version with a date.
Topics › Analytics engineering › In the weeds of data crafting
End to end: one question, every file it touches, and the ones that leave
Finance asks how much tuition recognised credit saves learners. Follow its question through the four phases and ten steps, one real commit per step: the files that arrive to stay, the ones that change, and the temporary ones, deleted when the work is done. Every file has a home named for its domain, and a lifetime. The series' closing film.
Builds on Written once
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 followed one question end to end. Now place each file, and follow one yourself.
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.
- A new question
models/marts/finance/_finance__conceptual.ymlmodels/marts/finance/_finance__decisions.ymlexposures/finance/models/_shared/_shared__conceptual.yml - What the core holds
analyses/profiling/profile_credit_across_awards.sqlseeds/reference/finance/tuition_rates.csvseeds/reference/finance/_finance__seeds.yml - One row of what
models/marts/finance/_finance__conceptual.ymlmodels/marts/finance/_finance__decisions.yml - The promise
models/marts/finance/_finance__models.ymlmodels/marts/finance/mart_finance__tuition_forgone.sqlexposures/finance/_finance__exposures.yml - Tests first
models/marts/finance/_finance__models.ymlseeds/expected/finance/tuition_report.csvtests/reconciliation/reconcile_finance_with_tuition_report.sql - The build
models/marts/finance/mart_finance__tuition_forgone.sql - Nothing else moved
analyses/validation/reconcile_tuition_report.sqlscripts/tools/diff_against_main.py - Review and ship
scripts/check/requirements.py - Written once
skills/review-metadata/find_repeats.pymodels/core/course/_course__columns.mdmodels/marts/finance/_finance__models.ymlmodels/marts/planning/_planning__models.yml - Ready to move
models/marts/finance/mart_finance__tuition_forgone.sqlmodels/marts/finance/exposures/finance/seeds/reference/finance/seeds/expected/finance/docs/conventions.md - The whole building
sources/models/core/models/marts/docs/conventions.md
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 10 of 10.