Amazon RDS Snapshot Export to S3 now available in eight additional AWS regions

Posted on: Jul 3, 2024

Snapshot Export to S3 for Amazon Aurora and Amazon RDS snapshots is now available in Asia Pacific (Hyderabad), Asia Pacific (Jakarta), Asia Pacific (Melbourne), Canada West (Calgary), Europe (Spain), Europe (Zurich), Israel (Tel Aviv), and Middle East (UAE) regions. Snapshot export to S3 exports snapshot data as Apache Parquet, an efficient open columnar storage format. Snapshot export to S3 allows ingestion of data stored in Amazon RDS and Amazon Aurora for purposes such as populating data lakes for analytics or for training machine learning models.

You can create an export with just a few clicks on the Amazon RDS Management Console or using the AWS SDK or CLI. 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 other AWS services such as Amazon Athena, Amazon SageMaker, or Amazon Redshift Spectrum or with big data processing frameworks such as Apache Spark.

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-Compatible Edition and Amazon Aurora MySQL snapshots. For more information, including instructions on getting started, read the Aurora documentation or Amazon RDS documentation.