Load Data into Autonomous Database from AWS S3
This example shows you how to load data from Amazon S3 object 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 AWS access credentials for user account authentication and an object URL for accessing the object in Amazon S3 bucket.
-
Create credentials for AWS user account in the Autonomous Database.
-
Copy data from the Amazon S3 bucket to the database.
Topics
- Prepare for Loading Data from AWS S3
Verify the prerequisites and prepare for loading data from Amazon S3. - Steps for Loading Data from AWS S3
Run these steps to load data from Amazon S3 to Autonomous Database.
Parent topic: Examples for Loading Data into Autonomous Database
Prepare for Loading Data from AWS S3
Verify the prerequisites and prepare for loading data from Amazon S3.
Prerequisites
data.txt
exists in the Amazon S3 bucket that you can import. The sample file in
this example has the following
contents:1,Direct Sales
2,Tele Sales
3,Catalog
4,Internet
5,Partners
On the AWS side, log in to your AWS account and do the following:
Parent topic: Load Data into Autonomous Database from AWS S3
Steps for Loading Data from AWS S3
Run these steps to load data from Amazon S3 to Autonomous Database.
SELECT * FROM mytable;
ID NAME
-- –-------------
1 Direct Sales
2 Tele Sales
3 Catalog
4 Internet
5 Partners
For more information about loading data, see Load Data from Files in the Cloud.
Parent topic: Load Data into Autonomous Database from AWS S3