Permission denied on S3 path

0

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

AWS
demandé il y a 2 ans510 vues
2 réponses
0

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

répondu il y a 2 ans
0

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

répondu il y a 9 mois
AWS
INGÉNIEUR EN ASSISTANCE TECHNIQUE
vérifié il y a 9 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions