Athena Table using S3

0

Hi,

We are trying to create a Athena table on Databricks Buckets, dbfs location in S3. It is giving us an error : Permission denied on S3 path: s3://bucket_name/regions-prod/databricks_env/Databricks_objects1/groups/groups.csv

Please suggest how to update the policy to allow Athena create a table using this path.

asked 3 months ago61 views
1 Answer
0

Athena requires access to the bucket and also to the folders and subfolders. Maybe compare your IAM permissions with this checklist and see if this helps [1] and also good troubleshooting references [2]

Reference :

  1. https://aws.amazon.com/premiumsupport/knowledge-center/access-denied-athena/
  2. https://docs.aws.amazon.com/athena/latest/ug/troubleshooting-athena.html
profile picture
EXPERT
answered 3 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