Skip to main content

profiles.yml Context

The following context variables and methods are available when configuring resources in the profiles.yml file.

Available context variables:

  • env_var
  • vars (Note: only variables defined with --vars are available)

Example usage#

~/.dbt/profiles.yml
jaffle_shop:  target: dev  outputs:    dev:      type: redshift      host: "{{ env_var('DBT_HOST') }}"      user: "{{ env_var('DBT_USER') }}"      password: "{{ env_var('DBT_PASS') }}"      port: 5439      dbname: analytics      schema: dbt_dbanin      threads: 4