Versions Compared

Version Old Version 21 New Version Current
Changes made by

Kalpana Malladi

Cindy Hall (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents

Overview

The Redshift Snap Pack will use 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. The existing pipelines configured either with the PostgreSQL JDBC driver or the Redshift JDBC driver will continue to work as expected. The new pipelines will 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 for issues with the PostgreSQL JDBC driver. Therefore, for such scenarios you must we recommend that you migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver before by November 2023.

Multiexcerpt include macro
nameRedshift limitation with PostgreSQL driver
templateData[]
pageRedshift - Execute
addpanelfalse

Migrating to the Amazon Redshift

...

JDBC driver

To migrate from the PostgreSQL to the Redshift JDBC driver as the default driver, update the JDBC Driver Class 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 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.

info
Panel
bgColor
#DEEBFF

  • For the JDBC URL, default indicate the Snap generated URL, while driver:

    • Default JAR indicates the driver that is bundled with the Snap Pack, and manual indicates the

    URL

    • driver that you

    provide

    • manually upload.

  • For the JDBC driver, default indicates the driver that is bundled with the Snap pack, while URL:

    • Default JAR indicate the Snap-generated URL, and manual indicates the

    driver

    • URL that you

    upload

    • manually specify.

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default/manual)

com.amazon.redshift.jdbc42.Driverdriver

jdbc:redshift (default/manual)

Authenticates successfully when the:

  • Default URL is used.

  • Default Amazon Redshift JAR file that is bundled with the Snap Pack is used.

  • Manually uploaded JAR file is used to connect to the database.

Redshift (manual upload)

com.amazon.redshift.jdbc42.Driverdriver

jdbc:redshift (default/manual)

Authenticates successfully using the manually uploaded JAR file and manually specified JDBC URL.

PostgreSQL (default/manual)

org.postgresql.Driverdriver

jdbc:postgresql (default/manual)

Authenticates successfully when the:

  • Default URL is used.

  • Default PostgreSQL

(Manual

  • JAR that is bundled with the Snap Pack is used.

  • Manually uploaded JAR file is used to connect to the database.

PostgreSQL (manual)

org.postgresql.Driverdriver

jdbc:postgresql (default/manual)

Authenticates successfully using the manually uploaded JAR file and manually specified JDBC URL.

Redshift JAR(manual)

org.postgresql.Driverdriver

jdbc:postgresql (default/manual)

Authenticates successfully using the default PostgreSQL JAR file.

PostgreSQL JAR(manual)

com.amazon.redshift.jdbc42.Driverdriver

jdbc:redshift (default/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 account cannot be authenticated because of the misaligned JDBC driver class and JDBC URL.

JDBC Driver JarJAR

JDBC Driver Class

JDBC URL

Authentication

Redshift JAR

com.amazon.redshift.jdbc42.Driverdriver

jdbc:postgresql

Authentication fails.

Redshift JAR

org.postgresql.Driverdriver

jdbc:redshift

Authentication fails.

PostgreSQL JAR

com.amazon.redshift.jdbc42.Driverdriver

jdbc:postgresql

Authentication fails.

PostgreSQL JAR

org.postgresql.Driverdriver

jdbc:redshift

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, when you configure Output fields and deselect Match data types checkbox. For instanceexample, 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, the Snap dislays displays the labels as configured in the Snap settings.:

...

With While with the Redshift DriverJDBC 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, irrespective regardless of using the PostgreSQL or the Redshift driver—the label names are displayed as configured in the Snap settings.

Batch Size

The behavior of the Redshfit Execute Snap with respect to the Batch Size varies for the two drivers:

...

Redshift JDBC Driver: If there is any invalid record within the batch, the entire batch of documents fail.

...

.