Using Data Studio with Autonomous AI Database
Use Data Studio in Oracle Autonomous AI Database to load, discover, catalog, transform, analyze, share, enrich, and automate data workflows from a web-based interface.
Data Studio is available from Oracle Database Actions, also known as SQL Developer Web. Database Actions is bundled with each Autonomous AI Database instance and provides development tools, data tools, administration, monitoring, and download features. The Data Studio area includes tools such as Data Load, Catalog, Data Insights, Data Transforms, and Data Analysis.
Prerequisites
Before using Data Studio, verify that the required OCI access, database access, and tool-specific roles are configured.
OCI IAM access
To open Database Actions and Data Studio from the Oracle Cloud Infrastructure Console, the user must have the required OCI IAM policy on Autonomous AI Database resources.
- Users with
read autonomous-databasesorinspect autonomous-databasescan open Database Actions from the Console but must provide a database username and password. - Users with
use autonomous-databasesormanage autonomous-databasescan automatically sign in to Database Actions from the Console as ADMIN.
Example IAM policy for Console access without automatic ADMIN login:
Example IAM policy for automatic ADMIN access from the Console:allow group ADB-Admins to manage autonomous-databases in tenancy```
Database Actions access
Database Actions access is schema-based. To use Database Actions, the user must sign in as a database user whose schema is enabled for Database Actions. The ADMIN user is enabled by default, and the ADMIN user can enable Database Actions access for other database users. See Connect with Built-In Oracle Database Actions for more details.
For non-ADMIN users, verify that:
- The database user exists.
- The user has Web Access enabled.
- The user has the required database roles for the Data Studio tools they need to use.
Required database roles
For non-ADMIN users, some Database Actions cards are hidden when the user does not have the required permissions. Data Studio tools such as Catalog, Data Load, Data Analysis, and Data Insights require DWROLE. Data Transforms requires DATA_TRANSFORM_USER.
| Tool or feature area | Required role or privilege |
|---|---|
| Data Studio tools, including Catalog, Data Load, Data Analysis, and Data Insights | DWROLE |
| Data Transforms | DATA_TRANSFORM_USER |
| Jobs in the user’s own schema | CREATE JOB |
| Jobs in another schema | CREATE ANY JOB \ |
Shared Data Studio settings
Some Data Studio features require shared configuration before use. Use Data Studio Settings to configure cloud object store access, AI profiles, SMTP, Marketplace settings, Slack notifications, vector indexes, and share-provider identity. See Data Studio Settings for reference.
| Configuration | Used by |
|---|---|
| Cloud object store credentials | Data Load, Catalog, Data Marketplace, Data Share, Data Transforms |
| AI profile | Table AI Assist, Natural Language Query, Vector Search, Catalog descriptions, Marketplace descriptions and tags |
| SMTP | Data Share and email notification workflows |
| Slack | Jobs notifications |
| Marketplace settings | Data Marketplace |
| Share provider identity | Data Share |
| Vector index settings | Data Analysis vector search |
Accessing Data Studio via Database Actions
To open Data Studio:
- Open the Autonomous AI Database Details page in the Oracle Cloud Infrastructure Console.
- Click the Database actions menu.
- Select View all database actions to open the Database Actions Launchpad.
- Select the Data Studio tab.
- Select the Data Studio tool that you want to use.
You can also open many Data Studio tools from the Database Actions selector menu. For example, Data Load, Catalog, Data Insights, and Data Analysis can be opened from the Data Studio tab or from the selector menu in Database Actions.
If the Autonomous AI Database uses a private endpoint, Database Actions can be accessed only from clients in the same Virtual Cloud Network.
Supported Data Studio Tools
| Data Studio tool | Use it to | Further Reference |
|---|---|---|
| Data Load | Load data, link external data, create live feeds, and manage connections. | Use Data Load with Autonomous AI Database |
| Catalog | Search, discover, inspect, load, link, query, and manage local or connected data assets. | Discover and Manage Data with Catalog in Autonomous AI Database |
| Data Transforms | Build graphical data loads, data flows, workflows, schedules, and transformation jobs. | Transform Data with Data Transforms in Autonomous AI Database |
| Data Analysis | Create Analytic Views, analyses, reports, SQL reports, and visual data analysis. | Analyze Data with Data Studio in Autonomous AI Database |
| Data Insights | Find patterns and potential anomalies in tables or Analytic Views. | Find Patterns and Anomalies with Data Insights in Autonomous AI Database |
| Data Marketplace | Publish, discover, load, analyze, and query curated marketplace datasets. | Share and Consume Data with Data Marketplace in Autonomous AI Database |
| Data Share | Provide and consume governed data shares using supported share types. | Share and Consume Data with Data Share in Autonomous AI Database |
| Table AI Assist | Prepare, enrich, and correct table data with natural language AI prompts. | Augment Data with Table AI Assist in Autonomous AI Database |
| Jobs | Automate Data Studio tasks, PL/SQL procedures, and REST calls. | Automate Data Studio Workflows with Jobs in Autonomous AI Database |