...
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 will continue to work as expected and the new pipelines will use the Redshift Driver as the default driver. However, the support for the PostgreSQL JDBC driver class will end by the November 2023 release.
Important:
SnapLogic will support providing fixes for the issues you might encounter with accounts using the PostgreSQL driver in with the Redshift Snap Pack only until November 2023. After November 2023, SnapLogic will no longer not provide support for the issues with the PostgreSQL driver. Therefore, in such scenarios, you must we recommend you to migrate from the PostgreSQL JDBC driver to the Redshift JDBC driver.
Migrating to Redshift Driver
...
Behavior Change from the PostgreSQL JDBC Driver to the Amazon Redshift JDBC Driver
Display of labels in the output for the Redshift Select Snap
For the Redshift Select Snap, the display of lables for the Output fields in the output preview varies with the two JDBC drivers. For instance, consider the following configuration of the Output fields in the Redshift Select Snap. On validation, notice the difference in the output.
...
With the Redshift Driver configured in the account, the Snap prefixes Redshift to the Timestamp label.
...
The labels are displayed as configured in the Snap, when you select the Match data types checkbox, irrespective of the PostgreSQL or the Redshift driver.
Batch Size
For The behavior of the Redshift Redshfit Execute Snap , when using Redshift Driver in the account, if with respect to the Batch Size varies for the two drivers:
Redshift JDBC Driver: If there is any invalid record within the batch the entire batch
...
of documents fail.
PostgreSQL Driver: If there is any invalid document, that document is passed to the error view and the remaining valid documents are passed to the output.