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