Skip to main content
/images/icon.png
Available for Enterprise Edition only.
Model configurations are settings that define how a model should be built and behave within your data warehouse. When you open a SQL project, you can find Configuration under the … ellipses menu in the project header. If you use a configuration in your model, you can switch to the code view to see the configuration encoded in the dbt_project.yml or schema.yml/properties.yml file.
See alsoFurther information can be found in the dbt documentation on model configurations.

​
Types

Configurations are variables that you can use in various gem fields. There are two types of configurations.
  • Model configurations: Only accessible in a specific model.
  • Project configurations: Accessible to any component within a specific project.

​
Syntax

The variable name and value should both be valid in Python. The way you reference these variables differ between model and project configurations. The table below shows some usage examples for each type of configuration.
TypePython SyntaxSQL Syntax
Modelkey{{ key }}
Projectvar("key", "defaultvalue"){{ var("key", "defaultvalue") }}
Note that the defaultvalue is optional for project configurations.