Posted On: Jun 1, 2017
You can now use the SELECT INTO OUTFILE S3 SQL statement to query data from an HAQM Aurora database cluster and save it directly into text files in an HAQM 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 HAQM S3. It’s an easy way to export data selectively to HAQM 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 HAQM Aurora version 1.13. You can read more in the HAQM 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 HAQM Aurora Pricing for regional availability.