Sarumyaa Posted Thursday at 02:15 PM Share Posted Thursday at 02:15 PM 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 Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted Friday at 07:15 AM Share Posted Friday at 07:15 AM 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now