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)

dbt-postgres v1.9.0rc1

dbt-postgres 1.9.0-rc1 - December 02, 2024

Breaking Changes

• Drop support for Python 3.8 (#161)

Features

• Enable setting current value of dbt_valid_to (#151)

Contributors

• @gshank (#151)
• @mikealfare (#161)

dbt-postgres v1.9.0b1

dbt-postgres 1.9.0-b1 - September 25, 2024

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)

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)
• @leahwicz (#109)
• @michelleark (#149)
• @mikealfare (#17, #96)
• @morsapaes (#120)
• @peterallenwebb (#123)
• @versusfacit (#85)

dbt-postgres v1.8.2

dbt-postgres 1.8.2 - June 20, 2024

Fixes

• Default to psycopg2-binary and allow overriding to psycopg2 via DBT_PSYCOPG2_NAME (restores previous behavior)

dbt-postgres v1.8.1

dbt-postgres 1.8.1 - May 23, 2024

Fixes

• Fix the semicolon semantics for indexes while respecting other bug fix