...

/

Project Variables

Project Variables

Learn to create project variables and use them in queries.

Project variables are a good way to define and store some configuration values that can be used across the whole project. They’re especially useful to define default values in our project.

Defining variables in the project.yml file

Let’s say we’re managing dbt projects for a chain of stores. Each store is likely to have a similar dbt project, except that their name and identifier are different.

We can define shop_name and shop_id as project variables to avoid having to hardcode those values in every model and macro ...