...
The JDBC Driver Class for Redshift Accounts is bundled with the Redshift driver com.amazon.redshift.jdbc42.Driver. 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 be using use the Amazon Redshift Driver as the default one going forwardfrom the March 2023 release.
Support for PostgreSQL driver as the default one will continue only up till until November 2023. After November, we will no longer support the PostgreSQL driver as the default one.
The existing pipeline still uses postgresql pipelines can use PostgreSQL driver as default one till November.
| Info |
|---|
Upgrade: To upgrade from the PostgreSQL driver to the Redshift driver as the default driver, you must update the Driver class name in the Account settings from “ |
...
If your account configuration is as shown below, then your accounts will be authenticated succesfullyuses 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 is as shown belowuses the following combination of JAR files, driver classes and JDBC URLs, then your accounts will are NOT be authenticated succesfullysuccessfully.
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. |
...