target

target contains information about your connection to the warehouse (specified in profiles.yml). Some configs are shared between all adapters, while others are adapter-specific.

Common

VariableExampleDescription
{{target.name}}devName of the active target
{{target.schema}}dbt_aliceName of the dbt schema (or, dataset on BigQuery)
{{target.type}}postgresThe active adapter being used. One of "postgres", "snowflake", "bigquery", "redshift"
{{target.threads}}4The number of threads in use by dbt

Snowflake

VariableExampleDescription
{{target.database}}RAWDatabase name specified in active target.
{{target.warehouse}}TRANSFORMName of the Snowflake virtual warehouse
{{target.user}}TRANSFORM_USERThe user specified in the active target
{{target.role}}TRANSFORM_ROLEThe role specified in the active target
{{target.account}}abc123The account specified in the active target

Postgres/Redshift

VariableExampleDescription
{{target.dbname}}analyticsDatabase name specified in active target.
{{target.host}}abc123.us-west-2.redshift.amazonaws.comThe host specified in active target
{{target.user}}dbt_userThe user specified in the active target
{{target.port}}5439The port specified in the active profile

BigQuery

VariableExampleDescription
{{target.project}}abc-123The project specified in the active profile