Register to Cloud Links for Accessing Data

Cloud Links enable you to remotely access read only data on an Autonomous AI Database instance.

You can register a table for remote access for a selected audience. Scope indicates who can remotely access the data. Scope can be set to various levels, including to the region where the database resides, to individual tenancies, or to compartments. You can provide a namespace and a name other than the original schema and object names. For example, you can register a table under the namespace FOREST and for security purposes or for naming convenience, you can provide a namespace and a name other than the original schema and object names.

To register a table to cloud link, click Actions next to the Table entity and select Register to Cloud Link.

Specify the following:

• Cloud Link Namespace: Enter a namespace to register the table. For example, ADMIN.

• Cloud Link Name: Enter a name for the cloud link. For example, Sales.

• Description: Specify the description of your cloud link.

• Scope: Specify who and from where a user can access the registered table.

  • My Region: You can grant remote data access to other tenancies in the region of the Autonomous AI Database instance that is registering the data set. This is the least restrictive scope.

  • My Tenancy: You can grant remote data access to any resource, tenancy, compartment, or database in the tenancy of the Autonomous AI Database instance that is registering the data set. This scope is more restrictive than My Region.

  • My Compartment: You can grant remote data access to any resource, compartment, or database in the compartment of the Autonomous AI Database instance that is registering the data set.

  • My Pool: You can grant remote data access to any resource, compartment, or database in the same Elastic Pool as the Autonomous AI Database instance that is registering the data set.

    This scope is more restrictive than My Tenancy and My Region, but broader than My Compartment, enabling secure, no-data-copy sharing within the pool, with permission checks done on the your database before connecting remotely.

  • OCID: Access to the data set is allowed for the specific Autonomous AI Database instances identified by OCID.

• Fast Refresh: Select this option to enable an incremental data refresh mode. This mode optimizes the response time significantly as it updates only the rows that are changed since the last refresh, rather than reloading the entire data set or a full refresh. It typically uses change tracking, for example, change data capture, timestamps, or materialized view logs to identify insert, update, and delete operations on the source and apply only the delta to the target.

Click OK to finish the registration of the selected table with the cloud link.