Load Data into Autonomous Database from AWS S3
This example shows you how to load data from Amazon S3 object storage to Autonomous Database using SQL commands.
This example uses 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