Permission denied on S3 path
(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.
- 最新
- 投票最多
- 评论最多
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
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:
- Athena does not have the permissions needed to access your S3 data
- The table queried does not exist
- The path is incorrect
- Your IAM user does not have permissions to use Athena/S3
- 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
