Snowflake Connector for PostgreSQL release notes

This topic provides release notes for the Snowflake Connector for PostgreSQL. For additional information, see Snowflake connector for PostgreSQL.

Version 6.6.1 (October 3rd, 2024)

Behavior changes

  • The maximum connection pool size to source databases has been increased to 7.

New features

Not applicable.

Bug fixes

  • The agent no longer stops after encountering data source connectivity issues.

  • The agent now confirms the PostgreSQL WAL position even when the QUOTED_IDENTIFIERS_IGNORE_CASE parameter is enabled for an account.

Version 6.6.0 (September 17th, 2024)

Behavior changes

Not applicable.

New features

  • You can now configure the agent through environment properties in addition to using snowflake.json and datasources.json for configuration.

  • You can now pass the private key contents through the snowflake.private-key property or SNOWFLAKE_PRIVATEKEY environment variable.

For more information, see Configure and run the agent.

Bug fixes

  • When schema introspection fails the operational warehouse suspends in the scheduled mode.

  • Fixed a bug where some commands to stop table replication were ignored in a few cases.

  • Fixed a bug where some source tables couldn’t be added to the replication and returned the error message Tables are not ready to be re-added.

Version 6.5.0 (August 27th, 2024)

Behavior changes

Not applicable.

New features

Not applicable.

Bug fixes

  • In continuous mode, the compute warehouse will now be able to suspend if there is no data to merge into destination tables.

Version 6.4.0 (August 16th, 2024)

Behavior changes

  • The connector now supports all known types of Postgres publications.

New features

  • Added support for all PostgreSQL DOMAIN types based on native data types.

Bug fixes

  • Corrected an issue where the connector could become stuck in a state where commands were not delivered to the agent.

Version 6.3.2 (July 15th, 2024)

Initial release of version 6.3.2.

Behavior changes

Not applicable.

New features

Not applicable.

Bug fixes

  • Fixed handling of deleted columns in subsequent schema changes.

  • Fixed compute warehouse not suspending in scheduled mode.

  • Fixed validation of reserved column names to be case insensitive.

  • Fixed MySQL tables failing replication on huge transactions.

Version 6.3.0 (July 11th, 2024)

Initial release of version 6.3.0.

Behavior changes

Not applicable.

New features

Not applicable.

Bug fixes

Not applicable.

Language: English