Skip to content

An error while communicating to amazon athena from tableau desktop

0

Bad connection: Tableau could not connect to the datasource. Error code: AA76601F com/amazonaws/ClientConfiguration
Unable to connect to the Amazon Athena server "athena.us-west-2.amazonaws.com". Check that the server is running and that you have access privileges to the requested database.

asked 3 years ago990 views
2 Answers
0

First, make sure you have the necessary IAM permissions
Next, make sure the endpoint you are connecting to is correct
Often the region is wrong
Next, make sure that the required JDBC drivers are installed
https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html

EXPERT
answered 3 years ago
  • athena.us-west-2.amazonaws.com ( both athena & s3 bucket are in oregon region)

0

Check if to connect to Amazon Athena you need ports 443 (ssl) and 444 to be open and also proper permissions are there. Also Athena connects to Tableau via an Athena JDBC driver, ensure you have proper version.

Reference

  1. https://aws.amazon.com/blogs/big-data/building-aws-data-lake-visualizations-with-amazon-athena-and-tableau/
  2. https://help.tableau.com/current/pro/desktop/en-us/examples_amazonathena.htm
AWS
EXPERT
answered 3 years ago
  • Note: To connect to Amazon Athena you need ports 443 (ssl) and 444 to be open. How to set these ports to be open?

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.