How to read DynamoJSON data in S3 to Athena

Question

I applied TTL in DynamoDb so that DynamoDB table will not bloat, using this tutorial : https://aws.amazon.com/blogs/database/automatically-archive-items-to-s3-using-dynamodb-time-to-live-with-aws-lambda-and-amazon-kinesis-firehose/

Now, this tutorial let me save my archived data in S3, in a format of DynamoJSOn. I have a problem reading it in Athena. How to access those data?

TTL data being saved in S3 looks like this:

folder structure is S3 is this: yyyy/mm/dd.

How to deal with this in Athena?

Answer 1

You can use an AWS Glue Crawler to infer the schema which can then easily be used by Amazon Athena.