4.3.5.1 Access Object Storage with Uniform Resource Identifiers (URI)

As of MySQL 9.3.1, (supported in MySQL HeatWave on OCI only) MySQL HeatWave Lakehouse lets you use Uniform Resource Identifiers (URI) in a unified way to specify Object Storage resources for loading data into MySQL HeatWave Lakehouse.

Before You Begin

• Review the following:

  • Additional MySQL HeatWave Lakehouse Requirements

  • MySQL HeatWave Lakehouse Privileges

  • Supported File Formats

URI Privileges

To use URIs, you require the existing privileges to use pre-authenticated requests and resource principals. See the following to learn more:

• To use PAR URIs, make sure you have the required PAR Privileges.

• To use Native URIs and OCIFS URIs, make sure you have the required Resource Principal Privileges.

What's Next

• Learn how to do the following:

  • Create External Tables Using Auto Parallel Load. Review Auto Parallel Load URI examples

  • Create External Tables Manually. Review manual URI examples.