dbt_project.yml
▶Changelog
Every dbt project needs a dbt_project.yml
file — this is how dbt knows a directory is a dbt project. It also contains important information that tells dbt how to operate on your project.
The following is a list of all available configurations in the dbt_project.yml
file.
YAML syntax
dbt uses YAML in a few different places. If you're new to YAML, it would be worth taking the time to learn how arrays, dictionaries and strings are represented.
dbt_project.yml
name: string
config-version: 2
version: version
profile: profilename
model-paths: [directorypath]
seed-paths: [directorypath]
test-paths: [directorypath]
analysis-paths: [directorypath]
macro-paths: [directorypath]
snapshot-paths: [directorypath]
docs-paths: [directorypath]
asset-paths: [directorypath]
target-path: directorypath
log-path: directorypath
packages-install-path: directorypath
clean-targets: [directorypath]
query-comment: string
require-dbt-version: version-range | [version-range]
quoting:
database: true | false
schema: true | false
identifier: true | false
models:
<model-configs>
seeds:
<seed-configs>
snapshots:
<snapshot-configs>
sources:
<source-configs>
tests:
<test-configs>
vars:
<variables>
on-run-start: sql-statement | [sql-statement]
on-run-end: sql-statement | [sql-statement]
dispatch:
- macro_namespace: packagename
search_order: [packagename]
0