[ ] bug fix PR with no breaking changes — please ensure the base branch is main
[X] new functionality — please ensure the base branch is the latest dev/ branch
[ ] a breaking change — please ensure the base branch is the latest dev/ branch
Description & motivation
Add materialization parameter to generate_base_model to allow users to choose whether to materialize the model as a table or a view.
Since base models ought not to do much transformation and provide a lightweight layer atop source tables, it is not uncommon to materialize them as views while having the default materialization for a project be tables, since heavier transformation models ought not be computed on the fly as they would be on a view.
This change would also make it possible to generate base models materialized as views in bulk using the dbt-generator package.
Checklist
[x] I have verified that these changes work locally
[x] I have updated the README.md (if applicable)
[ ] I have added tests & descriptions to my models (and macros if applicable)
This is a:
maindev/branchdev/branchDescription & motivation
Add
materializationparameter togenerate_base_modelto allow users to choose whether to materialize the model as a table or a view.Since base models ought not to do much transformation and provide a lightweight layer atop source tables, it is not uncommon to materialize them as views while having the default materialization for a project be tables, since heavier transformation models ought not be computed on the fly as they would be on a view.
This change would also make it possible to generate base models materialized as views in bulk using the dbt-generator package.
Checklist