Getting Access Denied error while querying a Glue Table using Athena

0

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: <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??

Vinay
asked 4 months ago385 views
1 Answer
0
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 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.

AWS
SUPPORT ENGINEER
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