Athena query "Access denied when writing to location: s3://***"
0
As the title, i've try to test a query to create a new database. The workgroup been set, 
And the odd part is the query result is failed, but the database is actually been created.
BTW, ive try the create a new table in this database too, same error of failed, but table is created. Is anyone can help me to solve this?
1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
I request you to check a few more things on your end:
- Are there any Access Control Lists enabled on your bucket? If yes, please check whether the account has the write permissions or not.
- Are the s3 bucket and the Athena not in the same account? If you are trying to access the s3 bucket which is in an account other than the account from which this Athena query has been run, then please follow this documentation.
- I think that within your bucket policy, another resource might be missing which is 'arn:aws:s3::<your-bucket>'. Please try to add this as well.
- Please check if there are any group permissions that are added on top of your role which is preventing the access to the s3 bucket for writing data.
