Skip to main content

database

models/<filename>.yml
version: 2
sources:  - name: <source_name>    database: <database_name>    tables:      - name: <table_name>      - ...

Definition#

The database that your source is stored in.

Note that to use this parameter, your warehouse must allow cross-database queries.

info

BigQuery terminology#

If you're using BigQuery, use the project name as the database: property.

Default#

By default, dbt will search in your target database (i.e. the database that you are creating tables and views).

Examples#

Define a source that is stored in the raw database#

models/<filename>.yml
version: 2
sources:  - name: jaffle_shop    database: raw    tables:      - name: orders      - name: customers