Which driver does Redshift Snap Pack uses?

Question

Which driver does Redshift Snap Pack uses today?  According to AWS blog, native Redshift drivers are more performant.  If it is not already using AWS distributed driver, how can we switch over?
“AWS recently launched free ODBC and JDBC drivers optimized for use with Amazon Redshift. These drivers improve performance over the use of open source drivers, and are more memory efficient.”
You can find more details in this AWS blog.

dmiller · Answer

Redshift Snap Pack version 2799 (a patch on the 4.8.0 codeline) or later has the properties to upload and enable the Redshift driver.

dmiller · Answer

The Redshift Snap Pack uses a Postgres driver, but you can upload the Redshift driver and configure the Redshift account to use that instead.

walkermic · Answer

upload them where/how?

dmiller · Answer

In the Redshift account, the JDBC Jars property lets you upload the drivers into SnapLogic.

walkermic · Answer

@dmiller I see now…the  “+” sign being below the box wasn’t intuitive to me.

Forum Discussion

Which driver does Redshift Snap Pack uses?

7 Replies

Recent Discussions

SFTP: Worked ok then settings changed not not working

SQS Consumer snap is ready all message at pipeline startup

Salesforce Update REST API Throughput

Using Windows Authentication with SQL Server Accounts

Preview not available for Flow snaps