...
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 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.
Migrating to Redshift Driver
...
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 varied combination of JDBC drivers, classes, and URLs of either the PostgreSQL or Redshift JDBC driver. Here are the configuration scenarios that are authenticated successfully.
...
|
|---|
...
|
|---|
...
|
|---|
...
|
|---|
...
|
|---|
...
|
|---|
...
| |||
|---|---|---|---|
JDBC Driver JAR | JDBC Driver Class | JDBC URL | Authentication |
Redshift (default) |
|
| Authenticates successfully. |
Redshift (manual upload) |
|
| Authenticates successfully using the manually uploaded JAR file. |
PostgreSQL (default) |
|
| Authenticates successfully. |
PostgreSQL (Manual) |
|
| Authenticates successfully using the manually uploaded JAR file. |
Redshift JAR |
|
| Authenticates successfully using the default PostgreSQL JAR file. |
PostgreSQL JAR |
|
| Authenticates successfully using the default Redshift JAR file. |
If your account configuration uses the following combination of JAR files, driver classes and JDBC URLs, then your accounts cannot be authenticated.
JDBC Driver JarJAR | JDBC Driver Class | JDBC URL | Authentication |
Redshift JAR |
|
| Authentication fails. |
Redshift JAR |
|
| Authentication fails. |
PostgreSQL JAR |
|
| Authentication fails. |
PostgreSQL JAR |
|
| Authentication fails. |
Behavior Change from the PostgreSQL JDBC Driver to the Amazon Redshift JDBC Driver
...
Batch Size
The behavior of the Redshfit Redshift Execute Snap with respect to the Batch Size varies for the two PostgreSQL and Redshift drivers:
Redshift JDBC Driver: If there is any invalid record within the batch, the entire batch of documents fail.
PostgreSQL JDBC Driver: If there is any invalid record within the batch, only the invalid document is passed to the error view and the remaining valid documents are passed to the output.
...