05-10-2017 04:16 PM
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.
05-10-2017 05:12 PM
The Redshift Snap Pack uses a Postgres driver, but you can upload the Redshift driver and configure the Redshift account to use that instead.
08-30-2018 12:13 PM
upload them where/how?
08-30-2018 01:03 PM
In the Redshift account, the JDBC Jars property lets you upload the drivers into SnapLogic.
08-30-2018 01:06 PM
@dmiller I see now…the “+” sign being below the box wasn’t intuitive to me.