In this article
Overview
The Redshift Snap Pack will use the Amazon Redshift driver com.amazon.redshift.jdbc42.Driver as the default driver class beginning from March 2023 (4.32.1.0) release. This upgrade is backward-compatible. The existing pipelines will continue to work as expected and the new pipelines will use the Redshift Driver as the default driver. However, the support for the PostgreSQL driver class will end by the November 2023 (4.35 release).
Important:
SnapLogic will support providing fixes for the issues you might encounter with accounts using the PostgreSQL driver in the Redshift Snap Pack until November 2023 (4.35 GA release).
After November 2023 (4.35 GA release), SnapLogic will NOT support providing fixes for the bugs that you might encounter 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 to the Redshift driver as the default driver, 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
If your account configuration uses the following combination of JAR files, driver classes and JDBC URLs, your accounts are authenticated successfully.
JDBC Driver Jar | JDBC Driver Class | JDBC URL | 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. |
If your account configuration uses the following combination of JAR files, driver classes and JDBC URLs, then your accounts are NOT authenticated successfully.
JDBC Driver Jar | JDBC Driver Class | JDBC Url | Authentication |
Redshift JAR |
| jdbc:postgresql | Authentication fails. |
Redshift JAR |
| jdbc:redshift | Authentication fails. |
PostgreSQL JAR |
| jdbc:postgresql | Authentication fails. |
PostgreSQL JAR |
| jdbc:redshift | Authentication fails. |