The problem I’m having
I’d like to define models common configs in the folder specific properties.yml file instead of in the global dbt_project.yml file.
I know this common config can be done using the resource path functionality, but that seems to be usable only in the dbt_project.yml file.
As our project grows bigger, we’d like to avoid growing our dbt_project.yml with a ton of common configs. We also think it would be more readable and maintainable to have a models folder specific common config inside the folder.
What I’ve already tried
I tried adding those line inside my models folder properties.yml file, but that is not taken into account
config:
+schema: MY_FOLDER_SCHEMA
models:
- name: model_1
config:
database: MY_DB
alias: TABLE_1
- name: model_2
config:
database: MY_DB
alias: TABLE_2
But that results in my models being represented in MY_DB.NONE.TABLE_{1, 2}.
Am I missing something regarding the resource path functionality? Is it possible to use this inside the properties.ymlfiles?