Load Data into Autonomous Database from Azure Blob Storage
This example shows you how to load data from Azure Blob Storage to Autonomous Database.
You have various options to perform data loading into Autonomous Database, such as:
-
Using UI options: You can use the Data Studio Load tool user interface to create credentials for the cloud store location, select files containing data, and run data load jobs.
-
Using Rest Data Services APIs: You can use the Data Studio Load tool APIs to create links to the cloud store location and run data load jobs.
-
Using SQL commands as explained in this example.
All these methods use the
same PL/SQL package DBMS_CLOUD
for loading data.
However, Data Studio provides additional benefits over SQL commands.
It not only helps to analyze the source and create table definitions
but also performs validation checks.
You require Azure access credentials for user account authentication and an object URL for accessing the object in your Azure Storage account container.
-
Create credentials for Azure user account in the Autonomous Database.
-
Copy data from Azure Blob Storage to the database.
Topics
- Prepare for Loading Data from Azure Blob Storage
Verify the prerequisites and prepare for loading data from Azure Blob Storage. - Steps for Loading Data from Azure Blob Storage
Run these steps to load data from Azure Blob Storage to Autonomous Database.
Parent topic: Examples for Loading Data into Autonomous Database
Prepare for Loading Data from Azure Blob Storage
Verify the prerequisites and prepare for loading data from Azure Blob Storage.
Prerequisites
azure-data.txt
exists in the
Azure Storage account container that you can import. The sample file in this example
has the following
contents:1,Azure Direct Sales
2,Azure Tele Sales
3,Azure Catalog
4,Azure Internet
5,Azure Partners
On the Azure side, log in to your Azure Storage account and do the following:
Steps for Loading Data from Azure Blob Storage
Run these steps to load data from Azure Blob Storage to Autonomous Database.
SELECT * FROM myazuretable;
ID NAME
-- –-------------
1 Azure Direct Sales
2 Azure Tele Sales
3 Azure Catalog
4 Azure Internet
5 Azure Partners
For more information about loading data, see Load Data from Files in the Cloud.