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 load structured data using Lakehouse Auto Parallel Load. Review URI examples.

• Learn how to load data manually. Review URI examples.

• To review the syntax for loading structured data using Lakehouse Auto Parallel Load, see Auto Parallel Load Syntax and Lakehouse External Table Syntax.