About properties.yml context

The following context methods and variables are available when configuring resources in a properties.yml file.

Available context methods:

• env_var
• var

Available context variables:

• target
• builtins
• dbt_version

Example configuration

properties.yml

# Configure this model to be materialized as a view
# in development and a table in production/CI contexts

models:
  - name: dim_customers
    config:
      materialized: "{{ 'view' if target.name == 'dev' else 'table' }}"