dbt_project.yml
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: stringversion: versionprofile: profilenamesource-paths: [directorypath]data-paths: [directorypath]test-paths: [directorypath]analysis-paths: [directorypath]macro-paths: [directorypath]snapshot-paths: [directorypath]docs-paths: [directorypath]asset-paths: [directorypath]target-path: directorypathlog-path: directorypathmodules-path: directorypathclean-targets: [directorypath]query-comment: stringrequire-dbt-version: version-range | [version-range]database: true | falseschema: true | falseidentifier: true | falsemodels:seeds:snapshots:sources:tests:vars:on-run-start: sql-statement | [sql-statement]on-run-end: sql-statement | [sql-statement]- macro_namespace: packagenamesearch_order: [packagename]