- Newest
- Most votes
- Most comments
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:
-
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:GetDatabaseandglue:GetTable. -
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.
-
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.
-
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.
-
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.
-
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
Relevant content
- AWS OFFICIALUpdated 2 years ago

That didn't work