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.

질문됨 2년 전5958회 조회
2개 답변
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.

답변함 2년 전
0

I fixed the issue.

답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠