HAQM RDS Snapshot Export to S3 now available in eight additional AWS regions
Snapshot Export to S3 for HAQM Aurora and HAQM 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 HAQM RDS and HAQM 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 HAQM 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 HAQM Athena, HAQM SageMaker, or HAQM Redshift Spectrum or with big data processing frameworks such as Apache Spark.
HAQM RDS Snapshot Export to S3 can export data from HAQM RDS for PostgreSQL, HAQM RDS for MariaDB, HAQM RDS for MySQL, HAQM Aurora PostgreSQL-Compatible Edition and HAQM Aurora MySQL snapshots. For more information, including instructions on getting started, read the Aurora documentation or HAQM RDS documentation.