You can create an export with just a few clicks on the Amazon RDS Management Console or using theAWS SDK orCLI. Extracting data from a snapshot doesn’t impact the performance of your database, as the export operation is performed on your snapshot and not your database. The extracted data in Apache Parquet format is portable, so you can consume it with query services such asAmazon Athena or big data processing frameworks such as Apache Spark. For more information, including instructions on getting started, read theAurora documentation or Amazon RDS documentation .
Amazon RDS Snapshot Export to S3 can export data from Amazon RDS for PostgreSQL, Amazon RDS for MariaDB, Amazon RDS for MySQL, Amazon Aurora PostgreSQL, and Amazon Aurora MySQL snapshots and is now available in US East (N. Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), and Asia Pacific (Tokyo) Regions.
Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. You can learn more about Amazon Aurora by visiting theproduct page.