In this article
| Table of Contents |
|---|
Overview
The JDBC Driver Class for Redshift Accounts is bundled with the Redshift Redshift Snap Pack uses the Amazon Redshift JDBC driver com.amazon.redshift.jdbc42.Driverdriver as the default driver class beginning from the March 2023 release. This upgrade is backward - compatible; however, the support for the PostgreSQL driver class will end in the November 2023 release. If you are using the PostgreSQL driver in your existing accounts, we recommend you to migrate from the PostgreSQL driver to the Redshift driver.
Things to remember:
Amazon Redshift Driver will be the default driver from the March 2023 (4.32.1.0) release. The new pipelines will use the Amazon Redshift Driver as the default one from the March 2023 release.
Support for PostgreSQL driver as the default will continue until November 2023. After November, we will no longer support the PostgreSQL driver as the default one.
The existing pipelines can use PostgreSQL driver as default one till November.
Info
Upgrade:
To upgrade from the PostgreSQL driver to the Redshift . The existing pipelines configured either with the PostgreSQL JDBC driver or the Redshift JDBC driver will continue to work as expected. The new pipelines use the Amazon Redshift JDBC driver as the default driver.Important:
SnapLogic will support providing fixes for the issues you might encounter with accounts that use the PostgreSQL JDBC driver only until November 2023, after which SnapLogic will not provide support. Therefore, we recommend that you migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver by November 2023.
| Multiexcerpt include macro | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Migrating to the Amazon Redshift JDBC driver
To migrate from the PostgreSQL to the Redshift JDBC driver as the default driver, you must update the JDBC Driver class nameClass in the Account settings from “org.postgresql.Driverdriver” to "com.amazon.redshift.jdbc42.Driverdriver" in your existing accounts.:
...
JDBC Driver Configuration Scenarios in Redshift Accounts
If your account configuration uses the following combination of JAR files, driver classes and JDBC URLs, your accounts are authenticated successfully.
...
Your pipelines might use a combination of JDBC drivers, classes, and URLs of either the PostgreSQL or the Amazon Redshift JDBC. Here are the configuration scenarios that are authenticated successfully.
| Panel | ||
|---|---|---|
| ||
|
JDBC Driver JAR | JDBC Driver Class | JDBC | UrlURL | Authentication |
Redshift (default/manual) |
| Jdbc | Authenticates successfully when the:
| |
Redshift (manual upload) |
| Jdbc | Authenticates successfully using the manually uploaded JAR file and manually specified JDBC URL. | |
PostgreSQL (default/manual) |
| Jdbc | Authenticates successfully when the:
| |
PostgreSQL (manual) |
|
| Authenticates successfully using the manually uploaded JAR file and manually specified JDBC URL. | |
Redshift JAR(manual) |
|
| Authenticates successfully using the default PostgreSQL JAR file. | |
PostgreSQL JAR(manual) |
|
| Authenticates successfully using the default Redshift JAR file. |
If your account configuration uses one of the following combination combinations of JAR files, driver classes, and JDBC URLs, then your accounts are NOT authenticated successfullyaccount cannot be authenticated because of the misaligned JDBC driver class and JDBC URL.
JDBC Driver JarJAR | JDBC Driver Class | JDBC UrlURL | Authentication |
Redshift JAR |
|
| Authentication fails. |
Redshift JAR |
|
| Authentication fails. |
PostgreSQL JAR |
|
| Authentication fails. |
PostgreSQL JAR |
|
| Authentication fails. |
Behavior Change
Display of labels in the output for the Redshift Select Snap
For the Redshift Select Snap, when you configure Output fields and deselect the Match data types checkbox, the display of the label name for the timestamptz data type in the output preview varies with the two JDBC drivers. For example, consider the following configuration of the Output fields in the Redshift Select Snap.
...
On validation, notice the difference in the label name in the output preview. With the PostgreSQL driver, Snap displays the labels as configured in the Snap settings:
...
While with the Redshift JDBC driver, the Snap prefixes Redshift to the Timestamp label. This does not impact the performance of the Snap.
...
The behavior of the Snap remains the same when you select the Match data types checkbox, regardless of using the PostgreSQL or the Redshift driver—the label names are displayed as configured in the Snap settings.