It has come to our attention after some testing, that some JDBC drivers for Redshift do not function completely.
For example, even though the Client tools (like SQL Workbench/J, DataIku DSS) may have a “Cancel Query” button. The button does not work. In fact, pushing it does nothing, and might lead the user to believe their SQL has been cancelled when in fact it has not. We know this from experience as we email users when we have to cancel long running queries and they tell us they already cancelled it – only it was not cancelled.
If you have ANY Client tools that connect to Redshift via JDBC, and they allow you to choose a JDBC driver please chose the driver that INCLUDES the AWS SDK like:
https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/1.2.41.1065/RedshiftJDBC42-1.2.41.1065.jar
These drivers that include the SDK are more complete in functionality.
The URL below contains a list of all Redshift JDBC drivers including the most current (RedshiftJDBC42-1.2.41.1065.jar) with the SDK included in the driver – ignore the ”previous-versions” the URL contains previous versions and the most current.
Note: DO NOT USE – the JDBC drivers on Amazon’s website that have “no-awssdk” in the filename, as these drivers do not have full functionality unless you have AWS Java SDK in your java CLASSPATH, which most people don’t.
Hope this helps.