...
From the March 2023 (4.32.1.0) release, the JDBC driver class for Redshift Accounts Snap Pack will use the Amazon Redshift driver com.amazon.redshift.jdbc42.Driver as the default driver. This upgrade is backward-compatible; however, the support for the PostgreSQL driver class will end by the November 2023 (4.34 release. Therefore, we recommend you to migrate from the PostgreSQL driver to the Redshift driver, if you are using the PostgreSQL driver in your existing accounts.).
...
Things to remember:
Amazon The new pipelines will use the Redshift Driver will be as the default driver from the March 2023 (4.32.1.0) release. The new existing pipelines will use the Amazon Redshift Driver as the default driver from the March 2023 release.
Support for the PostgreSQL driver as the default driver will continue until November 2023. So your existing Pipelines can use the PostgreSQL driver as the default one until November 2023. If you continue to use the PostgreSQL driver beyond November 2023, your Pipelines will break.
...
Upgrade:
continue to work as expected; if the accounts are configured to use either PostgresQL or Redshift driver the respective driver is used without any issues. SnapLogic will support providing bug fixes for the issues with accounts using the PostgrSQL driver in the Redshift Snap Pack until November 2023 (4.34 GA release).
After November 2023 (4.34 GA release), SnapLogic will not support providing fixes for the bugs that you might face with the accounts using the PostgreSQL driver. Therefore, in such scenarios you must migrate from the PostgreSQL driver to the Redshift driver.
Migrating to Redshift Driver
To migrate from the PostgreSQL driver to the Redshift driver as the default driver, you must update the JDBC Driver class name in the Account settings from “org.postgresql.Driver” to "com.amazon.redshift.jdbc42.Driver" in your existing accounts.
...
JDBC Driver Configuration in Redshift Accounts
...
JDBC Driver Jar | JDBC Driver Class | JDBC UrlURL | Authentication |
|---|---|---|---|
Redshift (default) |
| Jdbc:redshift (default/manual) | Authenticates successfully. |
Redshift (manual upload) |
| Jdbc:redshift (default/manual) | Authenticates successfully using the manually uploaded JAR file. |
PostgreSQL (default) |
| Jdbc:postgresql (default/manual) | Authenticates successfully. |
PostgreSQL (Manual) |
| jdbc:postgresql (default/manual) | Authenticates successfully using the manually uploaded JAR file. |
Redshift JAR |
| jdbc:postgresql (default/manual) | Authenticates successfully using the default PostgreSQL JAR file. |
PostgreSQL JAR |
| jdbc:redshift (default/manual) | Authenticates successfully using the default Redshift JAR file. |
...