Scale and Performance for Analytics Engineers
Scale and performance in dbt addresses large projects: selecting subsets of models with node selection, deferring to production state, building only what changed, and organising folders and packages. The aim is fast development and CI runs without rebuilding the whole project each time.
Stage: dbt in Depth · Part of the Analytics Engineer roadmap · Last reviewed 19 November 2026
What to learn in Scale and Performance
- Select models with graph operators such as plus and tag selectors
- Use state comparison to build only modified models
- Defer unchanged upstream models to production
- Split a large project into folders and packages
- Find the slowest models using run results
Scale and Performance interview questions
What is slim CI in dbt?
Slim CI builds and tests only the models changed in a pull request and their downstream dependants, using state from a previous production run and deferral for the rest. It keeps checks fast on large projects.
How do you find slow dbt models?
Inspect run timing from the run results artefact or the logs, sort models by duration, and examine the warehouse query profile for the slowest ones. Often the fix is a better materialisation, filter or join.
Where Scale and Performance fits in the Analytics Engineer roadmap
Scale and Performance belongs to the dbt in Depth stage (intermediate level), which takes about 7 hours. The core craft.
Other units in this stage
Back to the full Analytics Engineer roadmap