CODEWITHSUNDEEP
amazon-web-servicesamazon-iamamazon-athena
Harvesting Data
Harvesting Data

Reputation: 170

AWS account root user not able to query Athena tables

I have logged into AWS as the root account and still unable to query a Athena table that was created by another IAM User having Administrator Role. When I log off and login in as the IAM User which created the Tables, I am able to query.

Any inputs how can I grant permission to the AWS Root Account to the Athena Table (also available in the Glue Catalog) ?

Upvotes: 0

Views: 425

Answers (1)

Harvesting Data
Harvesting Data

Reputation: 170

This was because, the Admin role had not been granted access in Lakeformation to the given database which was being queried. Once, Admin role was assigned, the Account Owner was able to query the tables in the given database from Athena.

Upvotes: 0

Related Questions