vscode-dbt-power-user
vscode-dbt-power-user copied to clipboard
"generate model" from source should allow some customization
Describe the feature
When generating a model it does a few things that we prefer to not do:
- adds the code to use the proper quotes based on adapter (we don't quote our columns, ever)
- uses a cte to select * from the source (we list out all our columns explicitly and don't use a select * or cte)
would love to be able to set a flag or something to disable or change the default behavior. the generate model feature is a huge timesaver (even with the needed adjustments afterwards) and this would make things even better!
Describe alternatives you've considered
currently generating the model and removing the unneeded pieces not using the generation feature
Who will benefit?
anyone that doesn't need the quote logic..
Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
also need this option!
one more point, we use sqlfluff for formating without dbt formating and so generated models failed with
Undefined jinja template variable: 'adapter'sqlfluff(TMP)