4.6 Export Query Results to Object Storage

4.6.1 About Exporting Query Results

4.6.2 Requirements to Export Query Results

4.6.3 Export Query Results to CSV Files

4.6.4 Export Query Results to Parquet Files

4.6.5 Export Query Results to ND-JSON Files

4.6.6 Redacted PAR URLs in Exported Log Files

4.6.7 File Name Format for Exported Query Result Files

As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS.

The capability to convert the output into different file formats and write it directly to object storage helps to seamlessly integrate MySQL HeatWave with various data pipelines, analytics workflows, and downstream applications.

After exporting query results successfully, the output displays the number of rows written and the folder created to save the export query result.