Loading data from IBM Cloud Object Storage
Using Console
You can load data from IBM Cloud Object Storage (COS) into IBM® Db2® on Cloud by using the Console.
Create the necessary credentials on the COS bucket to allow Console to access the data
- Access the COS Bucket on the IBMCloud Dashboard by clicking on the name

Create Credentials on the COS bucket so Db2 Console can access the data.
- Select
Service Credentials
- Click on
New Credentials
- Enter
Name
for the Service Credential - Select the appropriate role
- Ensure
Include HMAC Credential
is enabled

Get the Access key
and Secret access key
from the Credentials
- Expand the Credential
- Note down the
access_key_id
andsecret_access_key

Open the Db2 Console to the load data page
- Click on
Data
on the left menu - Click on
Load Data
on the top tab - Click on
Cloud Object Storage
- Pick the
COS Authentication Endpoint
that matches your bucket - Enter the
access_key_id
from above forAccess key
- Enter the
secret_access_key
from above forSecret access key
- Click on
Browse Files
to select the file you want to load from

External Tables
You can load data from IBM Cloud Object Storage (COS) into IBM® Db2® on Cloud by using the built-in External Tables functionality.
Here's an example SQL statement that inserts COS data into a IBM Db2 Warehouse SaaS table by using External Tables:
INSERT INTO <table-name> SELECT * FROM EXTERNAL '<mys3file.txt>' USING
(CCSID 1208 s3('s3-api.us-geo.objectstorage.softlayer.net',
'<S3-access-key-ID>',
'<S3-secret-access-key>',
'<my_bucket>'
)
)