Skip to main content

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

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.

Back to the full Analytics Engineer roadmap