1 Answer
- Newest
- Most votes
- Most comments
0
To load the DynamoDB table data into Athena:
- Ensure the Glue crawler successfully crawled the DynamoDB table and added it to the Glue database with the correct schema.
- Check that the Glue table properties include
-
classification: dynamodb
- which indicates to Athena this table contains supplemental metadata.
- If the DynamoDB table or attribute names contain capital letters, edit the Glue table properties to map these to lowercase names which Athena supports.
- Refresh the Athena database to sync with any changes from Glue.
- Within Athena, select the database containing the DynamoDB table. The table should now be visible for querying.
Relevant content
- asked 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
Are you sure this works?, my understanding is that the way Glue DynamoDB tables and the Athena DynamoDB connector are different and incompatible