Load Data from Files in the Cloud

The PL/SQL package DBMS_CLOUD provides support for loading data from text, ORC, Parquet, and Avro files in the Cloud to your tables in Autonomous AI Database. In addition, using DBMS_CLOUD you can load Data Pump dump files in the Cloud to your tables in Autonomous AI Database.

The package DBMS_CLOUD supports loading files from the following cloud services:

• Oracle Cloud Infrastructure Object Storage

• Azure Blob Storage or Azure Data Lake Storage

• Amazon S3

• Amazon S3-Compatible, including: Wasabi Hot Cloud Storage

• GitHub Repository

• Google Cloud Storage

See DBMS_CLOUD URI Formats for more information.

Topics

• Create Credentials and Copy Data into an Existing Table

  For data loading from files in the Cloud, you need to first store your object storage credentials in your Autonomous AI Database and then use the procedure DBMS_CLOUD.COPY_DATA to load data.

• Create Credentials and Load Data Pump Dump Files into an Existing Table

  For data loading you can also use Oracle Data Pump dump files as source files.

• Load JSON on Autonomous AI Database

  The PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION provides support for loading JSON documents into SODA collections. The procedure DBMS_CLOUD.COPY_DATA provides support for loading JSON data into an existing table in Autonomous AI Database.

• Monitor and Troubleshoot COPY_DATA Loads

  All data load operations done using the PL/SQL package DBMS_CLOUD are logged in the tables dba_load_operations and user_load_operations. Use these tables to monitor loading with DBMS_CLOUD.COPY_DATA.

• Examples for Loading Data into Autonomous AI Database

  Provides examples for loading data in various formats and from different Cloud Storage providers into Autonomous AI Database.