Type object
File match dbt_project.yaml dbt_project.yml
Schema URL https://catalog.lintel.tools/schemas/schemastore/dbt-project/latest.json
Source https://raw.githubusercontent.com/dbt-labs/dbt-jsonschema/main/schemas/latest/dbt_project-latest.json

Validate with Lintel

npx @lintel/lintel check
Type: object

Properties

name string required
version string
analysis-paths string[]
asset-paths string[]
clean-targets string[]
config-version integer
Default: 2
data_tests Record<string, data_test_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all tests that don't have a more specific configuration set.

26 nested properties
+alias string
+database string
+enabled jinja_string | boolean
+error_if string
+fail_calc string
+group string
+limit integer
+meta object
+schema null | string
+severity jinja_string | string
+store_failures jinja_string | boolean
+warn_if string
alias string
database string
enabled jinja_string | boolean
error_if string
fail_calc string
group string
limit integer
meta object
schema null | string
severity jinja_string | string
store_failures jinja_string | boolean
warn_if string
dbt-cloud object
1 nested properties
project-id number
dispatch object[]
docs-paths string[]
flags object
23 nested properties
cache_selected_only boolean
debug boolean
fail_fast boolean
indirect_selection string
log_format string
log_format_file string
log_level string
log_level_file string
partial_parse boolean
populate_cache boolean
printer_width integer
require_explicit_package_overrides_for_builtin_materializations boolean
require_resource_names_without_spaces boolean
send_anonymous_usage_stats boolean
source_freshness_run_project_hooks boolean
static_parser boolean
use_colors boolean
use_colors_file boolean
use_experimental_parser boolean
version_check boolean
warn_error boolean
warn_error_options object
write_json boolean
log-path string
macro-paths string[]
model-paths string[]
models Record<string, model_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all models that don't have a more specific configuration set.

70 nested properties
+access string
Values: "private" "protected" "public"
+alias string
+auto_refresh boolean_or_jinja_string
+bind jinja_string | boolean
+contract object
1 nested properties
enforced jinja_string | boolean required
+copy_grants jinja_string | boolean
+database string
+docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
+enabled jinja_string | boolean
+file_format string
+full_refresh jinja_string | boolean
+grant_access_to object[]

Configuration, specific to BigQuery adapter, used to setup authorized views.

+grants object

grant config. each key is a database permission and the value is the grantee of that permission

+group string
+hours_to_expiration number

Configuration specific to BigQuery adapter used to set an expiration delay (in hours) to a table.

+incremental_strategy string
+kms_key_name string

Configuration, specific to BigQuery adapter, of the KMS key name used for data encryption.

+labels object

Configurations specific to BigQuery adapter used to add labels and tags to tables & views created by dbt.

+location string
+materialized string
+meta object
+on_configuration_change string
Values: "apply" "continue" "fail"
+on_schema_change string
Values: "append_new_columns" "fail" "ignore" "sync_all_columns"
+persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
+post-hook string[]
+pre-hook string[]
+schema null | string
+secure jinja_string | boolean
+snowflake_warehouse string
+sql_header string
+target_lag string
pattern=^(?:downstream|\d+\s*(?:seconds|minutes|hours|days))$
+tblproperties object
+transient jinja_string | boolean
access string
Values: "private" "protected" "public"
alias string
bind jinja_string | boolean
contract object
1 nested properties
enforced jinja_string | boolean required
copy_grants jinja_string | boolean
database string
docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
enabled jinja_string | boolean
file_format string
full_refresh jinja_string | boolean
grant_access_to object[]

Configuration, specific to BigQuery adapter, used to setup authorized views.

grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
hours_to_expiration number

Configuration specific to BigQuery adapter used to set an expiration delay (in hours) to a table.

incremental_strategy string
kms_key_name string

Configuration, specific to BigQuery adapter, of the KMS key name used for data encryption.

labels object

Configurations specific to BigQuery adapter used to add labels and tags to tables & views created by dbt.

location string
materialized string
meta object
on_configuration_change string
Values: "apply" "continue" "fail"
on_schema_change string
Values: "append_new_columns" "fail" "ignore" "sync_all_columns"
persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
post-hook string[]
pre-hook string[]
schema null | string
secure jinja_string | boolean
snowflake_warehouse string
sql_header string
target_lag string
pattern=^(?:downstream|\d+\s*(?:seconds|minutes|hours|days))$
tblproperties object
transient jinja_string | boolean
on-run-end array_of_strings | string
on-run-start array_of_strings | string
packages-install-path string
profile string
query-comment string | object
quoting object
3 nested properties
database jinja_string | boolean
identifier jinja_string | boolean
schema jinja_string | boolean
require-dbt-version string | array_of_strings
seed-paths string[]
seeds Record<string, seed_configs | empty_directory>
34 nested properties
+column_types object
+copy_grants jinja_string | boolean
+database string
+docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
+enabled jinja_string | boolean
+full_refresh jinja_string | boolean
+grants object

grant config. each key is a database permission and the value is the grantee of that permission

+group string
+meta object
+persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
+post-hook string | array_of_strings
+pre-hook string | array_of_strings
+quote_columns jinja_string | boolean
+schema null | string
+snowflake_warehouse string
+transient jinja_string | boolean
column_types object
copy_grants jinja_string | boolean
database string
docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
enabled jinja_string | boolean
full_refresh jinja_string | boolean
grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
meta object
persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
post-hook string | array_of_strings
pre-hook string | array_of_strings
quote_columns jinja_string | boolean
schema null | string
snowflake_warehouse string
transient jinja_string | boolean
semantic-models Record<string, semantic_model_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all semantic models that don't have a more specific configuration set.

6 nested properties
+enabled jinja_string | boolean
+group string
+meta object
enabled jinja_string | boolean
group string
meta object
snapshot-paths string[]
snapshots Record<string, snapshot_configs | empty_directory>
40 nested properties
+alias string
+check_cols string | array_of_strings
+database string
+docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
+enabled jinja_string | boolean
+grants object

grant config. each key is a database permission and the value is the grantee of that permission

+group string
+invalidate_hard_deletes boolean_or_jinja_string
+meta object
+persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
+post-hook string[]
+pre-hook string[]
+quote_columns jinja_string | boolean
+strategy string
+target_database string
+target_schema string
+transient jinja_string | boolean
+unique_key string | array_of_strings
+updated_at string
alias string
check_cols string | array_of_strings
database string
docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
enabled jinja_string | boolean
grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
invalidate_hard_deletes boolean_or_jinja_string
meta object
persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
post-hook string[]
pre-hook string[]
quote_columns jinja_string | boolean
strategy string
target_database string
target_schema string
transient jinja_string | boolean
unique_key string | array_of_strings
updated_at string
sources Record<string, source_configs | empty_directory>
6 nested properties
+enabled jinja_string | boolean
+meta object
enabled jinja_string | boolean
meta object
target-path string
test-paths string[]
tests Record<string, data_test_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all tests that don't have a more specific configuration set.

26 nested properties
+alias string
+database string
+enabled jinja_string | boolean
+error_if string
+fail_calc string
+group string
+limit integer
+meta object
+schema null | string
+severity jinja_string | string
+store_failures jinja_string | boolean
+warn_if string
alias string
database string
enabled jinja_string | boolean
error_if string
fail_calc string
group string
limit integer
meta object
schema null | string
severity jinja_string | string
store_failures jinja_string | boolean
warn_if string
unit_tests Record<string, unit_test_configs | empty_directory>
6 nested properties
+enabled jinja_string | boolean
+meta object
enabled jinja_string | boolean
meta object
vars object

Definitions

access string
alias string
array_of_strings string[]
auto_refresh jinja_string | boolean
backup jinja_string | boolean
boolean_or_jinja_string jinja_string | boolean
column_types object
contract object
enforced jinja_string | boolean required
data_test_configs Record<string, data_test_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all tests that don't have a more specific configuration set.

+alias string
+database string
+enabled jinja_string | boolean
+error_if string
+fail_calc string
+group string
+limit integer
+meta object
+schema null | string
+severity jinja_string | string
+store_failures jinja_string | boolean
+warn_if string
alias string
database string
enabled jinja_string | boolean
error_if string
fail_calc string
group string
limit integer
meta object
schema null | string
severity jinja_string | string
store_failures jinja_string | boolean
warn_if string
database string
docs_config object

Configurations for the appearance of nodes in the dbt documentation.

node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
empty_directory null
error_if string
fail_calc string
file_format string
grant_access_to object[]

Configuration, specific to BigQuery adapter, used to setup authorized views.

grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
hours_to_expiration number

Configuration specific to BigQuery adapter used to set an expiration delay (in hours) to a table.

incremental_strategy string
invalidate_hard_deletes jinja_string | boolean
jinja_string string
kms_key_name string

Configuration, specific to BigQuery adapter, of the KMS key name used for data encryption.

label_configs object

Configurations specific to BigQuery adapter used to add labels and tags to tables & views created by dbt.

limit integer
location string
materialized string
meta object
model_configs Record<string, model_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all models that don't have a more specific configuration set.

+access string
Values: "private" "protected" "public"
+alias string
+auto_refresh boolean_or_jinja_string
+bind jinja_string | boolean
+contract object
1 nested properties
enforced jinja_string | boolean required
+copy_grants jinja_string | boolean
+database string
+docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
+enabled jinja_string | boolean
+file_format string
+full_refresh jinja_string | boolean
+grant_access_to object[]

Configuration, specific to BigQuery adapter, used to setup authorized views.

+grants object

grant config. each key is a database permission and the value is the grantee of that permission

+group string
+hours_to_expiration number

Configuration specific to BigQuery adapter used to set an expiration delay (in hours) to a table.

+incremental_strategy string
+kms_key_name string

Configuration, specific to BigQuery adapter, of the KMS key name used for data encryption.

+labels object

Configurations specific to BigQuery adapter used to add labels and tags to tables & views created by dbt.

+location string
+materialized string
+meta object
+on_configuration_change string
Values: "apply" "continue" "fail"
+on_schema_change string
Values: "append_new_columns" "fail" "ignore" "sync_all_columns"
+persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
+post-hook string[]
+pre-hook string[]
+schema null | string
+secure jinja_string | boolean
+snowflake_warehouse string
+sql_header string
+target_lag string
pattern=^(?:downstream|\d+\s*(?:seconds|minutes|hours|days))$
+tblproperties object
+transient jinja_string | boolean
access string
Values: "private" "protected" "public"
alias string
bind jinja_string | boolean
contract object
1 nested properties
enforced jinja_string | boolean required
copy_grants jinja_string | boolean
database string
docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
enabled jinja_string | boolean
file_format string
full_refresh jinja_string | boolean
grant_access_to object[]

Configuration, specific to BigQuery adapter, used to setup authorized views.

grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
hours_to_expiration number

Configuration specific to BigQuery adapter used to set an expiration delay (in hours) to a table.

incremental_strategy string
kms_key_name string

Configuration, specific to BigQuery adapter, of the KMS key name used for data encryption.

labels object

Configurations specific to BigQuery adapter used to add labels and tags to tables & views created by dbt.

location string
materialized string
meta object
on_configuration_change string
Values: "apply" "continue" "fail"
on_schema_change string
Values: "append_new_columns" "fail" "ignore" "sync_all_columns"
persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
post-hook string[]
pre-hook string[]
schema null | string
secure jinja_string | boolean
snowflake_warehouse string
sql_header string
target_lag string
pattern=^(?:downstream|\d+\s*(?:seconds|minutes|hours|days))$
tblproperties object
transient jinja_string | boolean
on_configuration_change string
on_schema_change string
persist_docs_config object

Configurations for the persistence of the dbt documentation.

columns jinja_string | boolean
relation jinja_string | boolean
schema null | string
seed_configs Record<string, seed_configs | empty_directory>
+column_types object
+copy_grants jinja_string | boolean
+database string
+docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
+enabled jinja_string | boolean
+full_refresh jinja_string | boolean
+grants object

grant config. each key is a database permission and the value is the grantee of that permission

+group string
+meta object
+persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
+post-hook string | array_of_strings
+pre-hook string | array_of_strings
+quote_columns jinja_string | boolean
+schema null | string
+snowflake_warehouse string
+transient jinja_string | boolean
column_types object
copy_grants jinja_string | boolean
database string
docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
enabled jinja_string | boolean
full_refresh jinja_string | boolean
grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
meta object
persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
post-hook string | array_of_strings
pre-hook string | array_of_strings
quote_columns jinja_string | boolean
schema null | string
snowflake_warehouse string
transient jinja_string | boolean
semantic_model_configs Record<string, semantic_model_configs | empty_directory>

Configurations set in the dbt_project.yml file will apply to all semantic models that don't have a more specific configuration set.

+enabled jinja_string | boolean
+group string
+meta object
enabled jinja_string | boolean
group string
meta object
severity jinja_string | string
snapshot_configs Record<string, snapshot_configs | empty_directory>
+alias string
+check_cols string | array_of_strings
+database string
+docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
+enabled jinja_string | boolean
+grants object

grant config. each key is a database permission and the value is the grantee of that permission

+group string
+invalidate_hard_deletes boolean_or_jinja_string
+meta object
+persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
+post-hook string[]
+pre-hook string[]
+quote_columns jinja_string | boolean
+strategy string
+target_database string
+target_schema string
+transient jinja_string | boolean
+unique_key string | array_of_strings
+updated_at string
alias string
check_cols string | array_of_strings
database string
docs object

Configurations for the appearance of nodes in the dbt documentation.

2 nested properties
node_color string

The color of the node on the DAG in the documentation. It must be an Hex code or a valid CSS color name.

pattern=^(#[a-fA-F0-9]{3}|#[a-fA-F0-9]{6}|[^#][a-zA-Z]*)$
show boolean
Default: true
enabled jinja_string | boolean
grants object

grant config. each key is a database permission and the value is the grantee of that permission

group string
invalidate_hard_deletes boolean_or_jinja_string
meta object
persist_docs object

Configurations for the persistence of the dbt documentation.

2 nested properties
columns jinja_string | boolean
relation jinja_string | boolean
post-hook string[]
pre-hook string[]
quote_columns jinja_string | boolean
strategy string
target_database string
target_schema string
transient jinja_string | boolean
unique_key string | array_of_strings
updated_at string
snowflake_warehouse string
source_configs Record<string, source_configs | empty_directory>
+enabled jinja_string | boolean
+meta object
enabled jinja_string | boolean
meta object
sql_header string
strategy string
string_or_array_of_strings string | array_of_strings
tags string | array_of_strings
target_database string
target_lag string
target_schema string
tblproperties object
unit_test_configs Record<string, unit_test_configs | empty_directory>
+enabled jinja_string | boolean
+meta object
enabled jinja_string | boolean
meta object
updated_at string
warn_if string