New Database Driver Registration

[Kyle_Mac]

Another day, another request for help…

Currently I run SQL queries through Amazon Athena to return csv files. I want to do as much of this in Knime as possible so I am trying to configure my AWS Athena Connector node.

I can successfully connect through Amazon Authenticator, but get this error: Please register a compatible driver via the KNIME preference page. (For details see the log file)

I am not sure what details I should be adding in for new database driver registration. I have downloaded the JDBC connector from the AWS webpage but am not sure what to do with it.

[takbb]

Hi @Kyle_Mac , links for the general guide for registering the jdbc driver can be found on the help page for the Amazon Athena Connector on the hub here:

Amazon Athena Connector

For the more specific details of what details you are likely to need to enter, take a look at this post:

Knime v5 Athena Connector

Hello @MikePAM , sorry for the inconveniences. Unfortunately we had to remove the driver from the KNIME installation due to the licensing of the JDBC driver that is provided by Amazon. The license does not allow us to distribute the driver with the KNIME Analytics Platform. To register the driver do the following steps: Download the version 2 without the SDK (the pure jar file) of the driver from here. The current version 2.1.1.101 can be directly downloaded from here. Register the drive…

I’ve not used the Amazon Athena driver/connector myself, but if you still have further queries, please post back with screenshots of what you have configured, and details of your jdbc driver version (with any sensitive info obscured/redacted) and any error messages you are seeing. Hope that helps.

---

Additional note:

In Modern UI (at least in 5.2 onwards, and possibly before), jdbc drivers are registered via the Preferences button

and then selecting the Database section of the preferences page:

In Classic UI, find the preferences under the “File - Preferences” menu.

[tobias.koetter]

Hello @Kyle_Mac,
please install version 2.1.1 of the Amazon Athena JDBC driver, which you can download from here. For more details on how to register the driver see here.
Unfortunately the newer drivers are not compatible with KNIME. We are aware of this limitations and will work on it. The internal ticket number is AP-21705.
Bye
Tobias

[Kyle_Mac]

Thank you Tobias! I have got more help in 1 day from the Knime community than any other platform community I use.