Getting Access Denied error while querying a Glue Table using Athena


Getting below error while querying a Glue Table using Athena 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: <bucket>, Key: <prefix>/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??

asked 4 months ago385 views
1 Answer
Accepted Answer


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 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.

answered 4 months 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.

Guidelines for Answering Questions