Getting Access Denied error while querying a Glue Table using Athena

Question

Getting below error while querying a Glue Table using Athena

com.amazonaws.services.s3.model.AmazonS3Exception: Access Denied (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied; Request ID: YJSJ0PG0E56Z80R7; S3 Extended Request ID: /xxxxxxxxxxx==; Proxy: null), S3 Extended Request ID: /xxxxxxxxx/xxxxxxxx== (Bucket: , Key: /filename.txt/)
This query ran against the "test_glue_db" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: 4d3898a0-d82f-47e5-856d-614e3b88d792

Maybe this is because of that trailing slash in S3 key. But I don't know what causing this slash. Anyone having solution for it??

Accepted Answer

Hi,

Thank you for reporting this issue.

The shared error message, explains the IAM role used by Athena to query the S3 bucket does not sufficient permission to access the S3 bucket / Object.

Please double confirm the IAM user/role has sufficient permission to access the above shared S3 bucket / object. Example: `s3:ListBucket`.  Additionally, please check this [re:post](https://repost.aws/knowledge-center/access-denied-athena) that explains the root cause of this issue with workaround.

Also, I would like to suggest you to remove the S3 bucket details from this re:post as this could create security issue.
However, if you are unable to resolve this issue after adding the require permission, please create support ticket with us and we will help you to troubleshoot this issue further.

Getting Access Denied error while querying a Glue Table using Athena

Contenido relevante