Why are some of my AWS Glue tables missing in Athena?
Last updated: 2020-11-17
Some of the tables that I can see in the AWS Glue console aren't visible in the Amazon Athena console. Why is this happening?
The Athena console displays tables that point to Amazon Simple Storage Service (Amazon S3) paths only. AWS Glue can list tables that point to many different data sources, such as Amazon Relational Database Service (Amazon RDS) DB instances and Amazon DynamoDB tables. That's why you might see more tables in the AWS Glue console than in the Athena console.
To query data from sources other than Amazon S3 in Athena, use Athena Federated Query.