This section gives an overview of exporting query results to Object Storage.
You can export query results in the following ways.
Pre-Authenticated Request (PAR): Create a temporary URL that is the export destination for the query results. This option is only available for HeatWave on OCI. See Pre-Authenticated Request Requirements.
Resource Principal: Define the details to access OCI resources and export query results. This option is only available for HeatWave on OCI. See Resource Principal Requirements.
AWS S3 URL: For HeatWave on AWS, you must use AWS S3 URLs.
You can export the query results in the following file formats:
-
CSV (As of MySQL 9.1.1-u1)
-
Parquet (As of MySQL 9.1.1-u1)
-
Newline-Delimited JSON (As of MySQL 9.3.1)
Review the Requirements to Export Query Results.