Skip to content

Server Permission Error while integrating Tablaeu to Amazon Athena

0

Hi, I've established an S3 bucket that has a Glue Table Scheme, and while trying to integrate it with Athena, the Athena connector gives the following error:

Bad Connection: Tableau could not connect to the data source. Error Code: FAB9A2C5 Connection test failed: Could not get query execution ID: Service returned HTTP status code 404 (Service: Athena, Status Code: 404, Request ID: <Request ID>). Unable to connect to the Amazon Athena server "athena.eu-north-1.amazonaws.com". Check that the server is running and that you have access privileges to the requested database.

  1. I've ensured that my AWS role has both S3 and Athena Full Access, and that my bucket is in the corresponding region (eu-north-1).
  2. I've also downloaded the .jar driver and put it in ~/Library/Tableau/Drivers/.
  3. I've checked that ports 443, 444 are open and available.

Thanks.

1 Answer
0

Based on the error message and the steps you've already taken, it appears that the issue might be related to permissions or configuration rather than connectivity. Here are a few additional things to check:

  1. Ensure that the IAM role or user you're using has the necessary permissions to execute queries in Athena. While you mentioned having S3 and Athena Full Access, you might also need permissions for AWS Glue, as Athena uses the AWS Glue Data Catalog. Make sure your IAM role includes permissions for actions like glue:GetDatabase and glue:GetTable.

  2. Verify that the Athena workgroup you're trying to use exists and that you have the correct permissions to access it. The 404 error suggests that Athena couldn't find the resource you're trying to access, which could be due to an incorrect workgroup name or lack of permissions.

  3. Check that the Athena data source in Tableau is correctly configured with the proper region (eu-north-1 in your case), the correct workgroup name, and the appropriate S3 output location for query results.

  4. Ensure that your Glue Data Catalog is properly set up and that the database and table you're trying to query actually exist. You can verify this in the AWS Glue console.

  5. If you're using Lake Formation for fine-grained access control, make sure you have the necessary Lake Formation permissions granted to your IAM role or user.

  6. Double-check that the Athena JDBC driver version in Tableau is compatible with your Athena setup and Tableau version.

If the issue persists after verifying these points, you may need to check the CloudTrail logs for more detailed error messages or contact AWS support for further assistance.
Sources
Permissions to create and use a data source in Athena - Amazon Athena
Troubleshoot table errors - Amazon Athena
Troubleshoot issues in Athena - Amazon Athena

answered 2 years ago

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.