Autonomous Database Data Studio Features

Data loading

AI-enhanced data load

Prepare and load data using the power of AI and natural language. Data Studio AI Assist enables you to engineer and prepare your data by simply describing what you need in plain language.

Data transformation

GenAI pipelines in data transformation

Leverage a full-featured, built-in data integration tool for data engineers to design and run pipelines of data into Autonomous Database. Data transformation functionality now includes the ability to generate text and image vector embeddings in an Oracle Database 23ai instance of Autonomous Database using a simple drag-and-drop UI.

Data analysis

Smart business models

Create business models to describe related business entities derived from data in an Oracle Autonomous Database schema or other sources. The tool lets you create a common semantic model on top of your data identifying hierarchies, dimensions, measures, and calculations, which then can be used in several analysis applications, with query performance fully optimized by Oracle Autonomous Database.

Data insights

Automated data insights

Quickly gain insights and detect anomalies from your data using built-in algorithms from the business models constructed in the data analysis tool or from base tables.

Data governance

Find and understand your data

Understand data dependencies and the impact of changes. Use the catalog to get information about the entities in the database, such as data sets, data origination, a statistical analysis of each entity’s data, and the impact that changing the source of an entity may have on other entities.

Data sharing

Improve collaboration and decision-making across teams

Share data securely and efficiently across different departments, applications, and organizations. Delta Sharing enables data sharing for internal and external teams that do not use Autonomous Database or Oracle Cloud Infrastructure (OCI). Live Share simplifies optimized and native data sharing between Autonomous Database instances.