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:
- Execute failed: Could not initialize class com.simba.athena.amazonaws.ClientConfiguration
- 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.