Athena Table using S3

Question

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.

Answer

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

Athena Table using S3

Contenuto pertinente