All topics
Transformation / 30 guides
dbt Core
Commands, models, tests, Jinja and Snowflake recipes for dbt Core 1.x.
Everyday commands
- How to run only one model and its dependencies in dbt (+model, model+)
- How to run only modified models in dbt (state:modified+)
- How to exclude a folder or a tag from a dbt run
- How to pass variables to dbt run from the command line (--vars)
- How to rebuild an incremental model from scratch in dbt (--full-refresh)
- How to preview a model's result without building it in dbt (dbt show)
- How to see the compiled SQL of a model in dbt
Models and materializations
Tests
Macros and Jinja
Snowflake
- How to connect dbt to Snowflake with key-pair authentication (password auth blocked)
- How to query lowercase quoted columns from dbt in Snowflake
- How to fix "unique_key" duplicates failing an incremental model in dbt
- How to set the warehouse per model in dbt on Snowflake
- How to fix "Insufficient privileges… CREATE SCHEMA" in dbt