Is your feature request related to a problem? Please describe
Strategy for external models that don't need harmonization.
External models may have tables that will not require developer harmonization. We can take these tables out of all stb, and combined stages. Lookup tables can be ingested into the warehouse and read into dbt via the sources.yml. We would use dbt-model materialized=views within our access stage.
For example AccessDM.concept. This table could be created one time, and fit the exact needs of the access model.
We would create views in the access model stage so that the date are available within the access schema created for any of the environments.
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional Context
No response
Is your feature request related to a problem? Please describe
Strategy for external models that don't need harmonization.
External models may have tables that will not require developer harmonization. We can take these tables out of all stb, and combined stages. Lookup tables can be ingested into the warehouse and read into dbt via the sources.yml. We would use dbt-model materialized=views within our access stage.
For example AccessDM.concept. This table could be created one time, and fit the exact needs of the access model.
We would create views in the access model stage so that the date are available within the access schema created for any of the environments.
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional Context
No response