The problem I’m having
Trying to enforce the dbt model reads schema.yml from a different location
The context of why I’m trying to do this
There were some dbt packages models and schmea.yml will be recreated every single time when it runs dbt deps, those models are using the the auto generated schema.yml file in the same folder.
I would like have these models using different schema.yml file which saved in a different folder
What I’ve already tried
Try edit dbt_project.yml with different options, does not seems to be working
any points is much appreciated
Some example code or error messages
dbt/
├── projects/
│ └── project_pacakges/
│ └── schema_folder/
│ └── vendor_a_new.yml
│ └── dbt_packages/
│ └── vendor_a/
│ └── models/
│ └── sql_1.sql
│ └── sql_2.sql
│ └── vendor_a.yml
current: everything under dbt_packages/ will be recreate every single time run dbt deps, sql_1.sql and sql_2.sql are reading vendor_a.yml file.
what i like to achieve : sql_1.sql and sql_2.sql are reading vendor_a_new.yml file under schema_folder