How to Load Data From Public Cloud Storage into Autonomous Data Warehouse

 

Login to OCI console

 

Navigate to  Oracle Autonomous database -> Autonomous database . Then open your database and click on database actions.

 

This will open the Development and Data Tools options. From there, click on Data Load under the Data Tools section.

 

Now there are multiple ways as shown in the screenshot to load the data.
Here we have Selected Cloud Store, which allows loading data from Oracle OCI Object Store, Amazon S3, Azure Blob Storage, and other sources. Alternatively, you can choose to load data from a local file or database. After selecting your desired data option, click Next to proceed.

 

Then it will open the load cloud object section here we need to insert the cloud store link from where you want to load the data.

 

Once loaded we can now drag and drop the data files to make changes, as shown in the image below before loading the file.

 

 

Once all the changes are done to load the data simply click on the run button as highlighted to load the data.

 

Once the data has been successfully loaded, a check mark will appear indicating the task is complete. Afterward, click “Done” to finalize the data loading process.

 

For  reference