dbt-postgres v1.9.0

dbt-postgres 1.9.0 - December 09, 2024

Breaking Changes

• Drop support for Python 3.8 (#161)

Features

• Add tests for cross-database cast macro (#76)
• Cross-database date macro (#82)
• Add support for Python 3.12 (#17)
• Allow configuring snapshot column names (#144)
• Microbatch incremental strategy implementation: merge (#149)
• Enable setting current value of dbt_valid_to (#151)

Fixes

• Fix the semicolon semantics for indexes while respecting other bug fix (#85)
• Default to psycopg2-binary and allow overriding to psycopg2 via DBT_PSYCOPG2_NAME (restores previous behavior) (#96)
• Fix persist_docs for materialized_view materializations. Previously, using this configuration with materialized view models would lead to an error. (#120)

Under the Hood

• Add support for experimental record/replay testing. (#123)
• Updating changie.yaml to add contributors and PR links (#109)

Contributors

• @dbeatty10 (#76, #82)
• @gshank (#144, #151)
• @leahwicz (#109)
• @michelleark (#149)
• @mikealfare (#161, #17, #96)
• @morsapaes (#120)
• @peterallenwebb (#123)
• @versusfacit (#85)