...
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.Driver” to "com.amazon.redshift.jdbc42.Driver" 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, then your accounts cannot be authenticated because of the misaligned JDBC driver class and JDBC URL.
JDBC Driver JAR | JDBC Driver Class | JDBC URL | Authentication |
Redshift |
|
| Authentication fails. |
Redshift |
|
| Authentication fails. |
PostgreSQL |
|
| Authentication fails. |
PostgreSQL |
|
| Authentication fails. |
...
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 instance, 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 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, irrespective of using the PostgreSQL or the Redshift driver—the label names are displayed as configured in the Snap settings.