Hi community,
I keep on getting the following error when trying to connect to Athena with Tableau Desktop:
An error occurred while communicating with Amazon Athena
Bad Connection: Tableau could not connect to the data source.
Error Code: AA76601F
com/amazonaws/auth/AWSCredentials
Unable to connect to the Amazon Athena server "athena.eu-central-1.amazonaws.com". Check that the server is running and that you have access privileges to the requested database.
This is what I tried so far:
- I installed an updated version of java and verified that it's at the location:
C:\Program Files\Java\jre1.8.0_311
- I downloaded the update drivers for Athena and copied them to:
C:\Program Files\Tableau\Drivers\AthenaJDBC41_2.0.25.1002.jar
C:\Program Files\Tableau\Drivers\AthenaJDBC42_2.0.25.1002.jar
- I created a new user environment variable and system environment variable on my Windows machine
Variable name: JAVA_HOME
Variable value: C:\Program Files\Java\jre1.8.0_311
On AWS:
- I created a new user using IAM and gave him the following privileges for testing purposes
AmazonS3FullAccess
AmazonAthenaFullAccess
I copied the user "Access Key ID" and "Secret Key" provided to use in the Tableau application.
-
Verified the Query Result location path on the Athena settings
-
Verified that my account location is set to Frankfurt (eu-central-1) meaning that the endpoint is:
athena.eu-central-1.amazonaws.com
Then I tried to establish the connection from Tableau Desktop using the following parameters, but I keep on getting the same error reported at the beginning on the post.
Server: athena.eu-central-1.amazonaws.com
Port: 443
S3 Staging Directory: Query Result location path from the Athena settings
Access Key ID: ACCESS KEY COPIED FROM IAM
Secret Access Key: SECRET KEY COPIED FROM IAM
Thanks in advance for your help.