Skip to main content

About profiles.yml context

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

Available context methods:

  • env_var
  • var (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

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Edit this page