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.

posta un anno fa613 visualizzazioni
2 Risposte
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
ESPERTO
con risposta un anno fa
  • 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
ESPERTO
con risposta un anno fa
  • Note: To connect to Amazon Athena you need ports 443 (ssl) and 444 to be open. How to set these ports to be open?

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande