In this article
Overview
The Redshift Snap Pack will use the Amazon Redshift JDBC driver com.amazon.redshift.jdbc42.Driver as the default driver class beginning from March 2023 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 JDBC driver class will end by the November 2023 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.
After November 2023, SnapLogic will no longer support 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 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 cannot be authenticated.
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. |
Behavior Change from the PostgreSQL JDBC Driver to the Amazon Redshift JDBC Driver
Display of labels in the output for Redshift Select Snap
For the Redshift Select Snap, the display of lables for the Output fields in the output preview varies with the two JDBC drivers. For instance, consider the following configuration of the Output fields in the Redshift Select Snap. On validation, notice the difference in the output.
With the PostgreSQL Driver configured in the account, the Snap dislays the labels as configured in the Redshift Select Snap.
With the Redshift Driver configured in the account, the Snap prefixes Redshift to the Timestamp label.
Batch Size
For the Redshift Execute Snap, when using Redshift Driver in the account, if there is any invalid record within the batch the entire batch fails, whereas with the PostgreSQL Driver, the invalid document is passed to the error view and the valid documents are passed to the output.