Versions Compared

Version Old Version 19 New Version 20
Changes made by

Kalpana Malladi

Kalpana Malladi

Saved on

Key

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

...

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 configured either with the PostgreSQL JDBC driver or Redshift JDBC driver will continue to work as expected and the . 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 driver only until November 2023, after which there is no support provided SnapLogic will not provide support for issues with the PostgreSQL JDBC driver. Therefore, we recommend you to migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver before November 2023.

Migrating to Redshift Driver

...

If your account configuration uses the following combination of JAR files, driver classes and JDBC URLs, your accounts are authenticated successfully.

Info

  • For the JDBC URL, default indicate the Snap generated URL, while the manual indicates the URL that the user provides.

  • For the JDBC driver, default indicates the driver that is bundled with the Snap pack, while the manual indicates the driver that the user uploads.

JDBC Driver JarJAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default)

com.amazon.redshift.jdbc42.Driver

Jdbcjdbc:redshift (default/manual)

Authenticates successfully.

Redshift (manual upload)

com.amazon.redshift.jdbc42.Driver

Jdbcjdbc:redshift (default/manual)

Authenticates successfully using the manually uploaded JAR file.

PostgreSQL (default)

org.postgresql.Driver

Jdbcjdbc:postgresql (default/manual)

Authenticates successfully.

PostgreSQL (Manual)

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully using the manually uploaded JAR file.

Redshift JAR

org.postgresql.Driver

jdbc:postgresql (default/manual)

Authenticates successfully using the default PostgreSQL JAR file.

PostgreSQL JAR

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default/manual)

Authenticates successfully using the default Redshift JAR file.

...

JDBC Driver Jar

JDBC Driver Class

JDBC UrlURL

Authentication

Redshift JAR

com.amazon.redshift.jdbc42.Driver

jdbc:postgresql

Authentication fails.

Redshift JAR

org.postgresql.Driver

jdbc:redshift

Authentication fails.

PostgreSQL JAR

com.amazon.redshift.jdbc42.Driver

jdbc:postgresql

Authentication fails.

PostgreSQL JAR

org.postgresql.Driver

jdbc:redshift

Authentication fails.

...