Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

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.

Topics
AnalyticsStorage
Tags
Amazon AthenaAmazon Simple Storage Service
Language
English

asked 4 years ago524 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
AWS
EXPERT

answered 4 years 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.

Relevant content