Skip to main content

profile

dbt_project.yml
profile: string

Definition#

The profile your dbt project should use to connect to your data warehouse.

  • If you are developing in dbt Cloud: This configuration is optional
  • If you are developing locally: This configuration is required, unless a command-line option (i.e. --profile) is supplied.

Related guides#

Recommendation#

Often an organization has only one data warehouse, so it is sensible to use your organization's name as a profile name, in snake_case. For example:

  • profile: acme
  • profile: jaffle_shop
  • profile: evilcorp

It is also reasonable to include the name of your warehouse technology in your profile name. For example:

  • profile: acme_snowflake
  • profile: jaffle_shop_bigquery
  • profile: evilcorp_redshift

If you are working on more than one project, do not use profile: default as your profile name (as set by the dbt init command), as it will become hard to manage multiple profiles.