Which driver does Redshift Snap Pack uses?

[aleung]

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]

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]

upload them where/how?

[dmiller]

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

[walkermic]

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