Query DynamoDB with SQL using Athena - Leveraging DynamoDB Exports to S3 (1/2)

Export DynamoDB to S3 and query with Athena using SQL, unlocking powerful, scalable, and serverless data analytics

This is the first part of a two-part series covering how to copy data from DynamoDB to S3 and query it with Athena.

• Part 1 (this article): Query DynamoDB with SQL using Athena - Leveraging DynamoDB Exports to S3


• Part 2 (coming soon): Query DynamoDB with SQL using Athena - Leveraging EventBridge Pipes and Firehose

We will build two solutions using AWS CDK and TypeScript, covering both single-table and multiple-table designs.

Unlocking New Possibilities

The DynamoDB is a NoSQL database, and that fact comes with both the good and the bad. Among others, the good is that it is ultimately scalable; the bad is that it has limited query capabilities. You can squeeze out some additional query capabilities with a