Not able to connect with Tableau Desktop to Amazon Athena. Error: AA76601F

0

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:

  1. I installed an updated version of java and verified that it's at the location:

C:\Program Files\Java\jre1.8.0_311

  1. 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

  1. 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:

  1. 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.

  1. Verified the Query Result location path on the Athena settings

  2. 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.

asked 2 years ago5891 views
2 Answers
0

I managed to fix the issue.
On the Amazon download page for the Athen JDBC drivers:
https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html

it's possible to download JDBC Driver with AWS SDK and without AWS SDK. I erroneously download the latter one.

I downloaded now the JDBC Driver with AWS SDK and the connection works fine.

answered 2 years ago
0

I fixed the issue.

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions