1 Answer
- Newest
- Most votes
- Most comments
0
Hello.
The error you provided hints at an issue related SHOW TABLES command. Ensure that the IAM role or user associated with Athena has permissions like glue:GetTables, glue:GetDatabase, s3:GetObject, s3:PutObject, etc.
The error might be occurring because there's an inconsistency between what's registered in the Glue Data Catalog and what exists in the underlying S3 storage. To troubleshoot: Verify the tables registered in the Glue Data Catalog. Check the underlying S3 path for each table to ensure data/files exist as expected. Sometimes, manually removing and re-adding the table metadata to Glue can solve such inconsistencies.
Best regards, Andrii
Relevant content
- asked 9 months ago
- asked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 months ago