1 Changes in This Release

This section highlights new features, fixes, and enhancements in Database Actions for the current release.

Database Actions Release

• Registering to Cloud Links has a new scope, My Pool, and an option for Fast Refresh.

  See Register to Cloud Links for Accessing Data.

  The new scope is also added to the Marketplace Tool for publishing listings.

  See Data Studio Settings, Publish Listings to Marketplace.

• Delta Sharing supports JSON Profile version 2 using OIDC for Databricks.

  See Consume Versioned Share.

• Use new features, Tags and Custom Properties, on catalog entities for Metadata Enrichment.

  See Metadata Enrichment.

• Data Studio simplifies creating AI Profiles in a guided manner. Select a mode and create an AI Profile in a few clicks.

  See About AI Profiles.

Spreadsheet Add-ins offer a host of new features and improvements

• Support for catalog queries in Data Analysis.

• Oracle Autonomous Database add-in becomes Oracle Database add-in.

• Support for views in the Data Analysis panel.

• Natural Language query allows multiple tables selection.

• UX improvements in Direct SQL.

• Queries result appears as native tables.

Other minor UI improvements and fixes to Spreadsheet Add-ins include

• Deprecated packages are removed.

• Analytic View queries support pagination.

• Issues with filters in Data Analysis are fixed.

• Issues with the add-in installer on Windows are fixed.

Updates to the DBMS_CATALOG Package

Introduced new subprograms for Catalog Entity Management.

• GET_CLOUD_STORAGE_LINKS Function
• GET_COLUMNS Function
• GET_TABLE Procedure
• GET_TABLE Function

Introduced new subprograms for Catalog Property Management.

• GET_COLUMN_PROPERTY Function
• GET_COLUMN_PROPERTY_CLOB Function
• UPDATE_COLUMN_PROPERTY Procedure
• UPDATE_COLUMN_PROPERTY_CLOB 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

Introduced a new functional area Event Logging with CLEAR_CATALOG_EVENTS Procedure Procedure.

Introduced a new functional area Iceberg-Specific Management with the following subprograms.

• CREATE_ICEBERG_TABLE Procedure
• ADD_ICEBERG_SNAPSHOT Procedure

The following are enhanced with new parameters:

• CREATE_EXTERNAL_TABLE Procedure
• UPDATE_TABLE_PROPERTY_CLOB Procedure
• CREATE_SCHEMA Procedure