4.3.5 Access Object Storage

4.3.5.1 Access Object Storage with Uniform Resource Identifiers (URI)

4.3.5.2 Access Object Storage with Resource Principals

4.3.5.3 Access Object Storage with Pre-Authenticated Requests

MySQL HeatWave on OCI can access external data stored on Oracle Cloud Infrastructure in Object Storage.

MySQL HeatWave Lakehouse provides three methods to access Object Storage:

• Uniform Resource Identifier (URI) (Available as of MySQL 9.3.1 for MySQL HeatWave on OCI)

• Resource principal

• Pre-authenticated request (PAR)

For accessing external resources on MySQL HeatWave on AWS, see the following from the MySQL HeatWave on AWS Service Guide:

• To grant access to an Amazon S3 bucket, see Creating an IAM Role to Access an Amazon S3 Bucket.

• To allow MySQL HeatWave Lakehouse to process data in Amazon S3, see Creating Lakehouse Mapping.