Spotfire AWS Athena JDBC Connection Issue

[Sarumyaa]

Hello All,

We are trying to connect to AWS Athena using JDBC connectors for Information Designer in Spotfire. We tried two authentication methods: one using the AWS access key and secret key as the username and password, and another using the AWSCredentialsProvider. Both methods resulted in the below error.

[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. The security token included in the request is invalid. [Execution ID not available]

Also, when connecting to the AWS Athena database using the 3rd party tool Dbeaver we encountered the following error.

The security token included in the request is invalid. (Service: AmazonAthena; Status Code: 400; Error Code: UnrecognizedClientException; Request ID: 3306f809-c653-4b16-87e8-eae9f1454b31; Proxy: null)

Thanks,

Sarumyaa

[David Boot-Olazabal]

Hi Sarumyaa,

Did you create the data source template for AWS Athena by following the example on this page: https://community.spotfire.com/articles/spotfire/spotfire-jdbc-data-access-connectivity-details/?

Also, do you have the proper jdbc driver installed? Since it's not working in DBeaver as well, the connectivity problem seems to be beyond Spotfire.
There could be a few causes for this, like the credentials are lacking the necessary privileges.

Are you able to connect to AWS Athena with these credentials using a different way (for example directly or via an ODBC DSN)?

Kind regards,

David