Permission denied on S3 path

Question

(image removed)

Hi, 
I got the above error when I run the query "select * from mco_bi_data_definition". The table is created with the given file path. What do I need to do to resolve the issue?  
Here are the policies in my S3 bucket:
(image removed)

Many thanks.

*Edit: Removed Images - Ben G.

Answer

Did you see this article about athena permissions? There are other articles you may want to read in this same grouping that might help you, too. For example, there are specific athena permissions you are missing.

https://docs.aws.amazon.com/athena/latest/ug/federated-query-iam-access.html

Answer

Hello,
Providing more information about the type of error message you received would help us to find a resolution more quickly. Here are a few possible reasons for the error:
1.	Athena does not have the permissions needed to access your S3 data
2.	The table queried does not exist
3.	The path is incorrect
4.	Your IAM user does not have permissions to use Athena/S3
5.	The bucket policy is incorrect

For more information on Athena permissions:
https://docs.aws.amazon.com/athena/latest/ug/federated-query-iam-access.html

Athena troubleshooting guide:
https://docs.aws.amazon.com/athena/latest/ug/troubleshooting-athena.html

S3 Permissions Guide:
https://docs.aws.amazon.com/athena/latest/ug/s3-permissions.html

Permission denied on S3 path

Relevant content