alias

⚠️
 

Heads up!

This is a work in progress document. While this configuration applies to multiple resource types, the documentation has only been written for seeds.

Definition

Optionally specify a custom alias for a model or seed.

When dbt creates a relation (table/view) in a database, it creates it as: {{ database }}.{{ schema }}.{{ identifier }}, e.g. analytics.finance.payments

The standard behavior of dbt is:

  • If a custom alias is not specified, the identifier of the relation is the resource name (i.e. the filename).
  • If a custom alias is specified, the identifier of the relation is the {{ alias }} value.

To learn more about changing the way that dbt generates a relation's identifier, read Using Aliases.

Usage

Seeds

Configure a seed's alias in your dbt_project.yml file.

The seed at data/country_codes.csv will be built as a table named country_mappings.

dbt_project.yml
seeds:
jaffle_shop:
country_codes:
alias: country_mappings