IAM users can't see Athena tables

Question

My IAM users can't see the Athena tables I've created a long time ago using the root account.

Their group has the following permissions:

• AmazonS3FullAccess
• AmazonAthenaFullAccess

They only see the sampledb databases, which is unfortunate, because they need the one we actually use. The documentation is not clear on how to make the databases accessible to everyone. How do I achieve that?

Answer 1

Your permissions are correct.

Athena's context is not currently shared across regions. Ensure that the users are viewing Athena from the same region as the root account. When they login to AWS, they may be initially placed in another region.

Answer 2

You need Glue permissions, Glue is the service in charge of manage Databases and Tables in AWS