database
models/<filename>.yml
version: 2sources:- 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
raw
database
Define a source that is stored in the models/<filename>.yml
version: 2sources:- name: jaffle_shopdatabase: rawtables:- name: orders- name: customers