Athena Connector

[Edna_Roco_Prez1]

I am trying to connect KNIME to Amazon Athena using the Amazon Authentication node followed by the Amazon Athena Connector node. However, I am encountering errors related to credential initialization and apparent incompatibilities between the Athena JDBC driver (Simba) and the AWS SDK libraries bundled with KNIME.

I have tested several configurations, but the issue persists.

Errors Encountered:

1. Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration
2. Execute failed: Exception getting AWS credentials: Invalid connection parameter(s):
   Could not instantiate custom credentials provider
   “org.knime.cloud.aws.athena.credentials.provider.KNIMEAWSBasicSessionCredentialsProvider”
   because it does not implement software.amazon.awssdk.auth.credentials.AwsCredentialsProvider

Thank you in advance for any guidance, compatibility recommendations, or workarounds that could help resolve this issue with the Amazon Athena Connector.

[k10shetty1]

@Edna_Roco_Prez1 Welcome to the Forum.

New Database Driver Registration

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

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…

As mentioned in the threads above, the KNIME Athena Connector currently works only with the Athena JDBC v2 driver (without the AWS SDK).
If you are using a newer Simba driver or the “with SDK” variant, this will lead to the errors.

Could you check which exact driver JAR you have installed?
If it’s not a v2 without SDK driver, please download and register that version instead, as described in the above threads.

We’re aware of this limitation, and there is an internal ticket to track this: AP-21705.