Skip to content

CHANGELOG.md

Latest commit

 

History

History
144 lines (90 loc) · 7.43 KB

CHANGELOG.md

File metadata and controls

144 lines (90 loc) · 7.43 KB
Raw

Changelog

  • This file provides a full account of all changes to dbt-postgres
  • The format is based on Keep a Changelog, adheres to Semantic Versioning, and is generated by Changie
  • Changes are listed under the (pre-)release in which they first appear
  • Subsequent releases include changes from previous releases
  • "Breaking changes" listed under a version may require action from end users or external maintainers when upgrading to that version
  • Do not edit this file directly. This file is auto-generated using changie
  • For details on how to document a change, see the contributing guide

dbt-postgres 1.11.0-b2 - June 15, 2026

Dependencies

  • Add upper bound <2.0 on dbt-core to prevent pip from resolving to dbt-core 2.0 (Fusion engine), which is incompatible with the python adapter (#2013)

dbt-postgres 1.11.0-b1 - May 22, 2026

Features

  • Add autocommit support to eliminate idle-in-transaction states (#1608)
  • Added support for --empty in dbt seed (#1865)
  • Add support for python 3.14 (#12098)

Fixes

  • Enable discovering pre-existing functions by updating list_relations_without_caching to include function relations (#1488)
  • equals macro now uses IS NOT DISTINCT FROM clause for comparison (#1663)
  • When persist_docs.columns is enabled, dbt now warns about columns defined in YAML that don't exist in the database and eliminates a duplicate get_columns_in_relation roundtrip via the validate_doc_columns helper. (#1690)

Dependencies

  • Bump dbt-adapters floor to 1.24.1 for catalogs v2 and JS UDF support (#1965)

Contributors

dbt-postgres 1.10.0-rc2 - December 10, 2025

Features

  • Add support for UDF default arguments (#1442)
  • Add support for py3.13 (#1475)

Fixes

  • dbt-postgres no longer emits two BEGIN statements (#9434)

Contributors

dbt-postgres 1.10.0-rc1 - November 18, 2025

Under the Hood

  • Begin testing that python UDFs aren't supported (#1410)

Dependencies

  • Bump minimum dbt-adapters to 1.19.0 (#1421)

dbt-postgres 1.10.0-b2 - November 04, 2025

Features

  • Support volatility setting for sql UDFs (#1345)

Under the Hood

  • Test handling of unknown function macro lookup (#1344)

Dependencies

  • Drop support for python 3.9 (#1412)

dbt-postgres 1.10.0-b1 - October 07, 2025

Features

  • Initial UDF support for postgres (#1268)

Fixes

  • datetime.datetime.utcnow() is deprecated as of Python 3.12 (#980)
  • Optimize extremely slow query that uses a high amount of temporary disk space to find relations (#657)

Under the Hood

  • Migrate to a monorepo in dbt-adapters (#176)
  • Expand snapshot testing. (#1068)

Dependencies

  • Move minimum dbt-core to `1.8.0rc1` in order to allow for pre-releases of dbt-core (#1373)

Contributors

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

Previous Releases

For information on prior major and minor releases, see their changelogs: