AWS Database Blog
Author: Andreas Bogner
Andreas Bogner is a Global Solutions Architect at AWS based in Munich, Germany. He works with Automotive customers on large-scale cloud projects in the autonomous driving, manufacturing, and product innovation domains. A mathematician by training, he is obsessed with numbers and efficiency.
Turn petabytes of relational database records into a cost-efficient audit trail using Amazon Athena, AWS DMS, Amazon RDS, and Amazon S3
In this post, we show how you can use AWS Database Migration Service (AWS DMS) to migrate relational data from Amazon RDS into compressed archives on Amazon S3. We discuss partitioning strategies for the resulting archive objects and how to use S3 Object Lock to protect the archive objects from modification. Lastly, we demonstrate how to query the archive objects using SQL syntax through Athena with seconds latency, even on large datasets.