← Previous · Film 6 of 10
Built in layers
Four layers turn the tests green. Each layer has one job; each CTE, one step; and the rule is written once.
Topics › Analytics engineering › In the weeds of data crafting
Who owns what: owners publish, consumers build on what's published
In 1858, South Australia made the government's register the title: anyone could rely on it, and only its owner could change it. The credential's core models work the same way. Each fact's meaning has an owner, dbt's access says who can build on what, grants say who can read, and the keys stay shared.
Builds on Built in layers
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 who owns what. Now decide who can build on what.
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.
- Domains
sources/student_system/sources/learning_platform/sources/short_courses/models/core/student/models/core/course/models/marts/planning/exposures/planning/models/marts/wallet/exposures/wallet/models/_groups.yml - What a domain publishes
models/core/student/_core_student__models.yml - Private, protected, public
dbt_project.ymldocs/conventions.md - Who can read
dbt_project.yml - Across projects
examples/planning/dependencies.ymlexamples/planning/models/planning_enrolments_at_census.sqlexamples/planning/README.md - What stays shared
sources/student_system/_student_system__sources.ymlsources/learning_platform/_learning_platform__sources.ymlsources/short_courses/_short_courses__sources.ymlmacros/shared/keys.sqlexamples/planning/README.md - Groups first
models/_shared/_shared__decisions.ymlmodels/marts/planning/exposures/planning/seeds/expected/planning/models/marts/planning/_planning__decisions.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 7 of 10.
Next · Film 8 of 10 →
An agent on the team
An AI agent drafts in minutes. It follows rules written in the project, shows the query behind every claim, never weakens a test, and people approve.