4.6.2 Requirements to Export Query Results

Review the following requirements to export query results.

Required Privileges to Export Query Results

• Ask the admin user to grant you the EXPORT_QUERY_RESULTS privilege. Replace user_name and database_name in the following command with the appropriate user name and database name.

  mysql>GRANT EXPORT_QUERY_RESULTS ON database_name.* TO 'user_name'@'%';

• The resource principal policy for Exporting Query Results to Object Storage. See Resource Principal Privileges.

• The required pre-authenticated request privileges. See PAR Privileges.

• The required uniform resource identifier (URI) privileges. See URI Privileges.

Pre-Authenticated Request Requirements

When you create pre-authenticated requests (PAR) to export query results, do the following:

• For Pre-Authenticated Request Target, select Bucket or Objects with prefix.

• For Access Type, select Permit object reads and writes.

• Select Enable Object Listing.

See Object Storage Pre-Authenticated Requests from Oracle Cloud Infrastructure Documentation to learn more.

MySQL HeatWave on AWS Requirements

For MySQL HeatWave on AWS, you need the Lakehouse role to access Object Storage. This role is required even when Lakehouse is disabled. For more information, see Configure Policies and Roles to Access Resources.

What's Next

Depending on the type of file you want to create, review the appropriate section:

• Exporting Query Results to CSV Files

• Exporting Query Results to Parquet Files

• Exporting Query Results to JSON Files