4.6.1 About Exporting Query Results

This section provides an overview of exporting query results to Object Storage.

You can export query results in the following ways.

Uniform Resource Identifier (URI): Supported as of MySQL 9.3.1. Specify the details to access OCI resources with a URI. This option is only available for MySQL HeatWave on OCI. See OCIFS Documentation to learn more about OCIFS file format and its specifications.
Pre-Authenticated Request (PAR): Create a temporary URL that is the export destination for the query results. This option is only available for MySQL HeatWave on OCI. Learn more about Object Storage Pre-Authenticated Requests.
Resource Principal: Define the details to access OCI resources and export query results. This option is only available for MySQL HeatWave on OCI. Learn more about Resource Principals.
AWS S3 URL: For MySQL HeatWave on AWS, you must use AWS S3 URLs. See Manage AWS Access from the MySQL HeatWave on AWS Service Guide to learn more.

You can export the query results in the following file formats:

CSV (As of MySQL 9.1.1-u1)
See Exporting Query Results to CSV Files.
Parquet (As of MySQL 9.1.1-u1)
See Exporting Query Results to Parquet Files.
Newline-Delimited JSON (As of MySQL 9.3.1)
See Exporting Query Results to JSON Files.