...
The 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. 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.
...
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:
...
| Panel | ||
|---|---|---|
| ||
|
JDBC Driver JAR | JDBC Driver Class | JDBC URL | Authentication |
Redshift (default/manual) |
|
| Authenticates successfully. |
Redshift (manual) |
|
| Authenticates successfully using the manually uploaded JAR file. |
PostgreSQL (default/manual) |
|
| Authenticates successfully. |
PostgreSQL (manual) |
|
| Authenticates successfully using the manually uploaded JAR file. |
Redshift (manual) |
|
| Authenticates successfully using the default PostgreSQL JAR file. |
PostgreSQL (manual) |
|
| Authenticates successfully using the default Redshift JAR file. |
...
JDBC Driver JAR | JDBC Driver Class | JDBC URL | Authentication |
Redshift |
|
| Authentication fails. |
Redshift |
|
| Authentication fails. |
PostgreSQL |
|
| Authentication fails. |
PostgreSQL |
|
| Authentication fails. |
...
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.
...