Posted On: Jan 20, 2022
Amazon Relational Database Service (Amazon RDS) in Asia Pacific (Osaka) now offers export of snapshot data to Amazon S3 in Apache Parquet format, an efficient open columnar storage format for analytics. The Parquet format is up to 2x faster to export and consumes up to 6x less storage in Amazon S3, compared to text formats. The exported data can be analyzed using AWS tools such as Amazon Athena and Amazon SageMaker, or an open source big data framework such as Apache Spark.
Data can be exported with a few clicks using the Amazon RDS Management Console, or with the AWS SDK or CLI. There is no performance impact to an active database because data is extracted from the snapshot and not the database instance.
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 the Asia Pacific (Osaka) Region.
To get started, please refer the following resources: