0.13.0

What's Changed

Features

• Read upstream descriptions from sources by @esegal in #154
• Parameters in generate_source for case-sensitive identifiers by @pnadolny13 in #168

Fixes

• Escape upstream descriptions in generate_model_yaml by @wircho in #159
• Fix quoted identifiers in the generate_base_model macro for BigQuery by @dbeatty10 in #199

Docs

• fix generate_source example by @yatsky in #164
• Improve developer README by @gwenwindflower in #163
• Fix bad spacing in dev README by @gwenwindflower in #170
• Changelogs for 0.12.0, 0.12.1, and 0.13.0-b1 by @dbeatty10 in #196

Under the hood

• Restore CI test for case-sensitive identifiers when generating sources by @dbeatty10 in #192
• Remove Redshift-specific logic for toggling case-sensitive identifiers by @dbeatty10 in #208
• Use the cimg/postgres Docker image by @dbeatty10 in #214
• Independent CircleCI workflow job for each tested adapter by @dbeatty10 in #215
• Simplify environment variables for BigQuery in CircleCI by @dbeatty10 in #216
• Stop installing prereleases from PyPI in favor of stable releases only by @dbeatty10 in #220
• Upgrade to Python 3.11 in CircleCI by @dbeatty10 in #222
• Use dynamic schema names rather than hardcoded ones by @dbeatty10 in #224
• Add support for postgres testing in GitHub CI via tox by @emmyoop by @emmyoop in #181
• Add support for snowflake testing in GitHub CI via tox by @emmyoop in #198
• Add support for redshift testing in GitHub CI via tox by @emmyoop in #204
• Add support for bigquery testing in GitHub CI via tox by @emmyoop in #203

New Contributors

• @wircho made their first contribution in #159
• @esegal made their first contribution in #154
• @yatsky made their first contribution in #164
• @gwenwindflower made their first contribution in #163
• @pnadolny13 made their first contribution in #168
• @emmyoop made their first contribution in #181

Full Changelog: 0.12.1...0.13.0

v0.13.0-b1 Beta Release

This release adds case sensitivity to the generate_source macro, including database and schema configurations.

Importantly, this is being released as a beta as we are unable to test this functionality across all adapters, due to constraints in how dbt Core handles seeds. When those are resolved or we feel confident that any issues have been ironed out in the beta release, we'll cut a regular release of v0.13.0.

0.12.1

What's Changed

• Add dispatch to macros by @jeremyyeo in #148
• Remove terminal output in the generated file. by @vijmen in #149

New Contributors

• @jeremyyeo made their first contribution in #148
• @vijmen made their first contribution in #149

Full Changelog: 0.12.0...0.12.1

0.12.0

What's Changed

• Use print for outputting codegen by @JorgenG in #86

New Contributors

• @JorgenG made their first contribution in #86

Full Changelog: 0.11.0...0.12.0

0.11.0

What's Changed

• GitHub Action to add/remove triage labels as-needed by @dbeatty10 in #133
• GitHub Action to close issues as stale as-needed by @dbeatty10 in #134
• Update README.md by @cohms in #129
• Remove hard-coded values for database and schema by @dbeatty10 in #139
• Instructions for the release process by @dbeatty10 in #137
• Add include_data_types argument to generate_model_yaml macro by @linbug in #122

New Contributors

• @cohms made their first contribution in #129
• @linbug made their first contribution in #122

Full Changelog: 0.10.0...v0.10.0

0.10.0

What's Changed

• added comments to verbose regex in generate_model_import_ctes by @graciegoheen in #93
• Feature/hackathon model generator by @fivetran-joemarkiewicz in #83
• Suggestion to include packages.yml example in README.md by @Maayan-s in #77
• Add include_data_types flag to generate_source macro by @GSokol in #76
• Expected result of nested struct in BigQuery by @dbeatty10 in #105
• issue106/get_models helper macro by @erkanncelen in #115
• Feat/generate sources add database and schema by @jeremyholtzman in #124

New Contributors

• @fivetran-joemarkiewicz made their first contribution in #83
• @Maayan-s made their first contribution in #77
• @GSokol made their first contribution in #76
• @erkanncelen made their first contribution in #115
• @jeremyholtzman made their first contribution in #124

Full Changelog: 0.9.0...0.10.0

0.9.0

What's Changed

• Add the ability to generate yaml for multiple models at once by @angelica-lastra in #85
• Add the ability to specify the materialization of codegenned models by @davesgonechina in #79

New Contributors

• @angelica-lastra made their first contribution in #85
• @davesgonechina made their first contribution in #79

Full Changelog: 0.8.1...0.9.0

0.8.1

What's Changed

• A new macro – codegen.generate_model_import_ctes() – to kickstart the refactoring of legacy models to dbt best practices by @graciegoheen and the dbt Labs professional services team in #74

Full Changelog: 0.8.0...0.8.1

0.8.0

What's Changed

• update utils range @dave-connors-3 in #78

New Contributors

• @dave-connors-3 made their first contribution in #78

Full Changelog: 0.7.0...0.8.0

0.7.0

dbt-codegen v0.7.0

🚨 Breaking change

• Add support for including description placeholders for the source and table, which changes the behavior of generate_source when include_descriptions is set to True. Previous logic only created description placeholders for the columns (#64, #66)

New features

• Add optional table_names arg to generate_source (#50, #51)
• Add support for importing descriptions from columns with the same names in upstream models. It is available by setting the parameter upstream_descriptions to True in generate_model_yaml (#61)
• Added case_sensitive_cols argument to generate_base_model macro (#63)
• Add optional name arg to generate_source (#64, #66)

Fixes

• generate_model_yaml now correctly handles nested (STRUCT) fields in BigQuery (#27, #54)

Contributors:

• @rahulj51 (#51)
• @bodschut (#54)
• @b-per (#61)
• @graciegoheen (#63)
• @kbrock91 (#66)