Why are some of my AWS Glue tables missing in Athena?

Last updated: 2021-02-15

Some of the tables that I see in the AWS Glue console aren't visible in the Amazon Athena console. Why is this happening?

Resolution

You might see more tables in the AWS Glue console than in the Athena console for the following reasons:

  • You've created tables that point to different data sources. The Athena console displays tables that point to Amazon Simple Storage Service (Amazon S3) paths only. AWS Glue lists tables that point to different data sources, such as Amazon Relational Database Service (Amazon RDS) DB instances and Amazon DynamoDB tables.
  • You've created tables in formats that aren't supported by Athena, such as XML. These tables appear in the AWS Glue Data Catalog, but not in the Athena console.

To query data from sources other than Amazon S3 in Athena, use Athena Federated Query.


Did this article help?


Do you need billing or technical support?