Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt

Use this file to discover all available pages before exploring further.

/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 in the project settings menu beside the project name. 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.