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 a year ago590 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

profile picture
EXPERT
answered a year 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
profile pictureAWS
EXPERT
answered a year 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.

Guidelines for Answering Questions