An error while communicating to amazon athena from tableau desktop

Question

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.

Answer

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

Answer

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

An error while communicating to amazon athena from tableau desktop

相关内容