Access denied when accessing Athena in SQLalchemy

Question

Using pyathena and SQLalchemy, I connect to AWS Athena. If I use keys of AWS admin, all is working fine, can query data. If I use keys of an aws user that have AmazonAthenaFullAccess and AWSQuicksightAthenaAccess permissions, I get access deny. I have permission to the output S3, and Athena access a public data set S3 bucket. What permissions am I missing?

Thanks

I've had errors with pyathena generally. Are you able to test boto3 as an alternative to pyathena and see whether you get the same errors? Here is the relevant documentation: medium.com/@devopsglobaleli/introduction-17b4d0c592b6 — olisteadman

Alexander Alexander · Accepted Answer · 2019-09-06T16:55:47

AmazonAthenaFullAccess policy provides access to S3 buckets such as: "arn:aws:s3:::aws-athena-query-results-" and "arn:aws:s3:::athena-examples". You have 2 options:

Create a new policy and add content from AmazonAthenaFullAccess policy, but with different S3 resources.
Add AmazonS3FullAccess policy to your user, which grants permissions for all your S3 buckets

Access denied when accessing Athena in SQLalchemy

1 Answers