Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• Data Studio Overview
• The Data Load Page
  • Data Studio Settings
    • Slack Integration
    • About AI Profiles
      • Create an AI Profile
      • Manage AI Profiles
  • Managing Connections
    • Create Credentials
    • Create Oracle Cloud Infrastructure Native Credentials
    • Create Amazon Web Services (AWS) Credentials
    • Manage Resource Principal with DBMS_CLOUD
    • Register Data Catalog
  • Loading Data
    • Use OCI Language Service Capabilities in Data Studio
      • Overview of Sentiment Analysis, Key Phrase Extraction and Language Detection
      • Parameters to Analyze Data
      • Perform Sentiment Analysis
        • Output Data Generated from OCI Sentiment Analysis
      • Perform Key Phrase Extraction
        • Output Data Generated from OCI Key Phrase Extraction
      • Perform Language Detection
        • Output Data Generated from OCI Language Detection
      • Perform Text Translation
        • Output Data Generated from OCI Text Translation
    • Use OCI Document Understanding to extract Tables from Images
      • Overview of Table Extraction
      • Perform Table Extraction from Image
    • Use GeoJSON in Data Load
      • Add Spatial Expression for GeoJSON columns
      • Parameters for Spatial Data Analysis
      • Perform Spatial Analysis
      • Output Data Generated from Spatial Analysis
    • Load Apache Iceberg Tables
    • Loading Data from File System
      • Create Directories in Database Actions
    • Loading Data From Local Files
    • Loading Data from Other Databases
      • Load Data from Oracle and Non-Oracle Databases using Database Links
    • Loading Data from Cloud Storage
      • Manage Cloud Storage Links for Data Load Jobs
      • Prepare the Data Load Job
      • Add Files or Folders for the Data Load Job
      • Enter Details for the Data Load Job
      • Run the Data Load Job
      • View Details About the Data Load Job After It Is Run
      • View the Table Resulting from the Data Load Job
    • Loading Data from AI Source
    • Loading Data from Share
    • Create Live Feed from Data Load
  • Linking Data
    • Linking to Other Databases
    • Linking to Objects in Cloud Storage
      • Manage Cloud Storage Links for Data Link Jobs
      • Prepare the Data Link Job
      • Add Files or Folders for the Data Link Job
      • Enter Details for the Data Link Job
      • Run the Data Link Job
      • View Details About the Data Link Job After It Is Run
      • View the Table Resulting from the Data Link Job
    • Linking to File System
    • Linking to Share
    • Linking to Data Catalog
  • Feeding Data
    • Creating a Notification-Based Live Table Feed
    • Creating a Notification-Based Live Table Feed using Amazon Simple Storage Service (S3)
    • Creating a Notification-Based Live Table Feed using Microsoft Azure
    • Send Email using Live Feed Tool
  • DBMS_LIVE_FEED Package Reference
    • Summary of DBMS_LIVE_FEED Subprograms
• The Catalog Tool
  • About the Catalog Page
  • Browse and Search Catalogs
  • Sorting and Filtering Entities
  • Filter Entities
  • Display Entity Search
  • Catalog Settings
  • Metadata Enrichment
  • Manage Catalogs
    • Manage Catalog Cache
    • Inline Data Load of Delta Share from the Catalog Tool
    • Query Remote Catalogs and Databases
      • Conceptual Diagram of Querying Remote Catalogs
      • Concepts related to querying remote catalogs and databases
      • About Querying Remote Catalogs and Databases
      • Examples: List the Mounted Catalogs
      • Examples: List the Tables in a Catalog, Including Their Owning Schemas
      • Examples: Query Data from a Table in a Catalog
      • Examples: Query a Table from a Delta Share and Analyze the View
  • Viewing Entity Details
    • Autonomous Database Entity Details
  • Register to Cloud Links for Accessing Data
  • Export Data to Cloud
  • Gathering Statistics for Tables
  • Editing Tables
    • Columns Pane
    • Primary Key Pane
    • Unique Keys Pane
    • Indexes Pane
    • Foreign Keys Pane
    • Table Constraints Pane
    • Comments Pane
    • Storage Pane
    • External Table Properties Pane
    • Materialized View Pane
    • DDL Pane
    • Output Pane
  • Manage Catalogs with DBMS_CATALOG
    • DBMS_CATALOG Package
    • Summary of DBMS_CATALOG
      • MOUNT_DATA_CATALOG Procedure
      • MOUNT_DB_LINK Procedure
      • MOUNT_ICEBERG Procedure
      • MOUNT_SHARE Procedure
      • MOUNT_SHARES Procedure
      • MOUNT_VIRTUAL_CATALOG Procedure
      • UNMOUNT Procedure
      • GET_CATALOG_PROPERTY Procedure
      • GET_CATALOG_PROPERTY_CLOB Procedure
      • UPDATE_CATALOG_PROPERTY Procedure
      • UPDATE_CATALOG_PROPERTY_CLOB Procedure
      • GET_COLUMN_PROPERTY Function
      • GET_COLUMN_PROPERTY_CLOB Function
      • UPDATE_COLUMN_PROPERTY Procedure
      • UPDATE_COLUMN_PROPERTY_CLOB Procedure
      • GET_SCHEMA_PROPERTY Procedure
      • GET_SCHEMA_PROPERTY_CLOB Procedure
      • UPDATE_SCHEMA_PROPERTY Procedure
      • UPDATE_SCHEMA_PROPERTY_CLOB Procedure
      • GET_TABLE_PROPERTY Procedure
      • GET_TABLE_PROPERTY_CLOB Procedure
      • UPDATE_TABLE_PROPERTY Procedure
      • UPDATE_TABLE_PROPERTY_CLOB Procedure
      • ADD_REQUIRED_CREDENTIAL Procedure
      • REMOVE_REQUIRED_CREDENTIAL Procedure
      • RENAME_REQUIRED_CREDENTIAL Procedure
      • GET_REQUIRED_CREDENTIAL_PROPERTY Procedure
      • UPDATE_REQUIRED_CREDENTIAL_PROPERTY Procedure
      • GET_LOCAL_CREDENTIAL_MAP (Overloaded) Procedure
      • SET_LOCAL_CREDENTIAL Procedure
      • GET_CLOUD_STORAGE_LINK_PROPERTY Function
      • GET_CLOUD_STORAGE_LINK_PROPERTY_CLOB Function
      • UPDATE_CLOUD_STORAGE_LINK_PROPERTY Procedure
      • UPDATE_CLOUD_STORAGE_LINK_PROPERTY_CLOB Procedure
      • CREATE_CLOUD_STORAGE_LINK Procedure
      • DROP_CLOUD_STORAGE_LINK Procedure
      • GET_CLOUD_STORAGE_LINKS Function
      • GET_COLUMNS Function
      • CREATE_EXTERNAL_TABLE Procedure
      • CREATE_SCHEMA Procedure
      • DROP_SCHEMA Procedure
      • GET_OBJECTS Procedure
      • GET_SCHEMAS Procedure
      • GET_TABLES Procedure
      • GET_TABLE Procedure
      • GET_TABLE Function
      • DROP_TABLE Procedure
      • GENERATE_TABLE_SELECT (Overloaded) Procedure
      • OPEN_TABLE_CURSOR Procedure
      • FLUSH_CATALOG_CACHE Procedure
      • PREFILL_CATALOG_CACHE Procedure
      • CREATE_SYNCHRONIZED_SCHEMAS Procedure
      • DROP_SYNCHRONIZED_SCHEMAS Procedure
      • UPDATE_SYNCHRONIZED_SCHEMA_PROPERTY Procedure
      • SYNCHRONIZE_SHARED_CATALOGS Procedure
      • CREATE_SYNCHRONIZED_VIEWS Procedure
      • COPY_TABLE_PROPERTIES Procedure
      • GRANT_TO_RECIPIENT Procedure
      • REVOKE_FROM_RECIPIENT Procedure
      • CLEAR_CATALOG_EVENTS Procedure
      • CREATE_ICEBERG_TABLE Procedure
      • ADD_ICEBERG_SNAPSHOT Procedure
• The Data Insights Page
  • About Insights
  • Generate Insights and View Reports
• The Data Analysis Tool
  • Searching and obtaining information about Analytic Views
  • Creating Analytic Views
  • Working with Analyses
  • Viewing Analyses
  • Workflow to build Analyses
  • Format Numeric Columns in the Data Analysis Tool
  • Creating Analyses
    • Saving Analyses
  • Creating Reports
    • Working with Reports
    • Creating Reports on a Query
    • Creating Reports on an Analytic View
  • Run Natural Language Query in the Data Analysis Tool
    • Generate SQL Queries From Natural Language on Analytic Views
    • Generate SQL Queries from Natural Language on Tables
  • Generate Natural Language explanation from SQL Query using AI Explain
  • Vector Search in the Data Analysis Tool
  • Using Calculation Templates
    • Cumulative Aggregates
    • Prior and Future Period
    • Period to Date
    • Parallel Period
    • Moving Aggregates
    • Share
    • Rank
  • Use Oracle Database for Spreadsheet Add-ins
    • About Oracle Database for Spreadsheet Add-ins
      • Privacy Policies and Contact Details
    • Installation Options for Spreadsheet Add-ins
      • Download Spreadsheet Add-ins from Database Actions
      • Install Add-in for Microsoft Excel from Trusted Catalogs
      • Install Add-in for Excel from Office Store
      • Install Add-on for Google Sheets from Google Workspace Marketplace
    • Connect to Autonomous AI Database from a Spreadsheet
    • Manage Connections
    • Access the Spreadsheet Add-in by OCI IAM Domains
    • Use Role-Based Access Control for IAM Authentication
      • Configure Role-Based Access Control Manually
      • Set up Role-Based Access Control Automatically using a Script
    • Using Spreadsheet Add-ins Features
      • UI Options in Spreadsheet Add-ins
      • Run Natural Language Queries
      • Run Direct SQL Queries
      • Perform Data Analysis using Spreadsheet Add-ins
      • Access and Share Data using Table Hyperlinks
    • Manage Settings
    • Remove Spreadsheet Add-ins
    • Troubleshoot Scenarios with Spreadsheet Add-ins
• The Data Marketplace Tool
  • Access Data Marketplace Tool
  • Publish Listings to Marketplace
  • Consume Dataset
  • DBMS_DATAMART Package Reference
    • Summary of DBMS_DATAMART Subprograms
• The Table AI Assist Tool
  • Prepare Data Using Table AI Assist Tool
    • Add a Column
    • Replace a Column
    • Remove a Column
    • Rename a Column
    • View Statistical Details about the Table you Load after you Create a Recipe
  • View Table Entity Details
  • Conversational AI for the Table AI Assist Tool
• The Jobs Feature
  • How to Access the Jobs Feature?
  • Conceptual Diagram of the Jobs Feature
  • Create a Job
  • Manage and Monitor the Job
  • DBMS_DATA_TOOLS_JOBS Package Reference
    • Summary of DBMS_DATA_TOOLS_JOB Subprograms
• The Data Share Tool
  • Overview of the Data Share Tool
  • Access and Enable the Data Share Tool
  • Provide Share
    • Provide Share Overview
    • Provide Versioned Share
    • Provide Live Share
    • View Share Entity Details
    • Create Share Recipient
    • View Share Recipient Entity Details
  • Consume Share
    • Consume Share Overview
    • Consume Versioned Share
    • Enable File-Level Change Data Feed Access for Versioned Shares
    • Consume Live Share
    • View Share Provider Entity Details
    • Sharing Databricks Tables with Deletion Vectors
  • Manage Shares with DBMS_SHARE
  • Data Share Limitations on Autonomous AI Database
  • Troubleshooting Errors with the Data Share Tool
    • Live Share Feature Slow Performance
    • Shared Table Query Attempt Failure
    • HTTP 403 Unauthorized Due to Remote IP Allowlist
  • FAQs on the Data Share Tool