Posted On: Jun 1, 2017

You can now use the SELECT INTO OUTFILE S3 SQL statement to query data from an Amazon Aurora database cluster and save it directly into text files in an Amazon S3 bucket. This means you no longer need the two-step process of bringing the data to the SQL client and then copying it from the client to Amazon S3. It’s an easy way to export data selectively to Amazon Redshift or any other application.

Files created by this statement can be used by the corresponding LOAD DATA FROM S3 statement to load data into an Aurora database cluster. The export and import capabilities are both available in Amazon Aurora version 1.13. You can read more in the Amazon Aurora documentation.

To learn more about Aurora, a MySQL-compatible relational database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases, visit the Aurora product page.  Please see Amazon Aurora Pricing for regional availability.