Module · Data Engineer
Data Transformations
Versioned SQL models, tests that protect them and documentation nobody has to guess at.
TOPIC 01
Models & Projects
The project layout, and the staging layer that keeps everything else readable.
What you'll practice
- Lay Out the Project — guided · beginner
- Write a Staging Model — practice · intermediate
A command you'll meet
cat ~/dbt/dbt_project.ymlA transformation that is not versioned is a transformation you cannot trust. Open the task below for the full walkthrough.
Hands-On Tasks in This Topic (2)
Lay Out the Project
The project file decides where the models live and which profile they run with. Write it.
Write a Staging Model
A staging model is a view that renames, casts and nothing else. Write one that the rest of the warehouse can rely on.
TOPIC 02
Tests & Documentation
The checks that fail the build, and the documentation that makes a model usable.
What you'll practice
- Write the Tests — practice · intermediate
- Document the Models — challenge · advanced
A command you'll meet
cat ~/dbt/models/schema.ymlA model nobody can trust is a model nobody should query. Open the task below for the full walkthrough.
Hands-On Tasks in This Topic (2)
Write the Tests
Tests are the contract with the people who query the model. Write the schema file with the generic and the singular tests.
Document the Models
Documentation is what turns a table into a product. Write the rules for describing the models and for declaring who consumes them.