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.
相关内容
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前
