Load Data with Data Studio Tools

The Data Load dashboard in Data Studio allows you to load data into Oracle Autonomous AI Database from files, databases, cloud storage, shares, file systems, and AI sources. This dashboard acts as a common place to load data into database tables, link to data that remains in an external source, create live table feeds from cloud storage, and manage the connections used by these tasks.

Data Load is available from Oracle Database Actions. Database Actions is bundled with each Autonomous AI Database instance, and the Data Studio tools, including Data Load, require the DWROLE database role for non-ADMIN users.

See The Data Load Page for an overview of the dashboard, entry points, dashboard tiles, and Data Load navigation.

When to use Data Load

Use Data Load when you want a guided web interface for common data-ingestion tasks in Autonomous AI Database.

Use it to:

• Load data into tables in Autonomous AI Database from local files, remote databases, cloud storage, directories, shares, or AI sources.

• Link data when you want to query data in remote databases or cloud storage without copying all source data into the database. Linked data creates external tables or views, and changes in the source are reflected when the linked data is queried.

• Create a live feed when files are added to cloud storage over time and you want Autonomous AI Database to load those files on demand, on a schedule, or based on notifications.

• Manage connections for cloud storage, data catalogs, and share providers used by Data Studio data-loading workflows.

Use other Autonomous AI Database loading options, such as DBMS_CLOUD, Oracle Data Pump, SQL*Loader, or data pipelines, when you need a programmatic, administrative, or bulk-movement workflow outside the Data Studio interface. See Load Data into Autonomous AI Database to learn about these data-loading options.

How Data Load works with Autonomous AI Database

Data Load runs in the context of the Autonomous AI Database user that opens Database Actions. Loaded data is created as database objects in Autonomous AI Database. Linked data is exposed through database objects such as external tables or views. Live feeds automate loading from cloud storage into database tables, and connections store the cloud storage, catalog, or share-provider information used by Data Studio.

To open Data Load:

1. Open Database Actions for your Autonomous AI Database.
2. Select the Data Studio tab.
3. Select Data Load.

You can also open Data Load from the Database Actions selector menu. If you do not see the Data Load card or menu entry, ask an administrator to grant the required DWROLE role.

What you can do from the Data Load dashboard

The Data Load dashboard includes these main areas:

• Load Data: Load data into Autonomous AI Database tables from supported sources such as local files, databases, cloud storage, directories, shares, file systems, and AI sources.

  See Loading Data for details about the procedures and options for loading data from local files, databases, cloud storage, file systems, shares, and AI sources.

• Link Data: Create external tables or views that reference data in cloud storage, remote databases, shares, file systems, or OCI Data Catalog sources.

  See Linking Data for details about the procedures and concepts for linking to data in remote databases, cloud storage, directories, shares, and OCI Data Catalog.

• Live Feed: Configure recurring, on-demand, or notification-based loading from cloud storage into Autonomous AI Database tables.

  See Feeding Data for details about the procedures for live table feeds from cloud storage, including scheduled and notification-based feeds.

• Connections: Create and manage cloud storage links, data catalog links, and share-provider subscriptions used by Data Studio.

  See Managing Connections for details about the procedures for creating and managing cloud storage links, data catalog links, and share-provider connections.

Refer to Data Studio documentation for details about the supported sources, file formats, options, mappings, job behavior, and step-by-step procedures for using the Data Load feature.