• Store your object storage credentials in your Autonomous Database
• Create a database link or use an existing database link
• Mount the database link as a catalog

• Name of the database link
• Cloud credentials required to access the data

1. Iceberg Endpoint: Set up Polaris or Unity Catalog using the Iceberg REST API. This involves specifying the catalog type, URI, and warehouse location. You will need the REST endpoint for your external Iceberg catalog. This is the URL that provides access to the Iceberg metadata.

   Example: https://your-iceberg-catalog.com/api/v1/iceberg

2. Token Endpoint: The /v1/oauth/tokens endpoint is provided by Iceberg REST catalogs to issue Bearer Token.
3. Client ID & Client Secret: These are credentials provided by the OAuth server to identify your application (in this case, the Unity and Polaris Catalog integration). You will use these credentials to generate Bearer Token.
4. Bearer Token: To authenticate requests to the Iceberg REST endpoint, you will use OAuth with the Client Credentials. The Catalog tool calls the token endpoint to receive Bearer Token.
5. Namespace: A namespace is equivalent to a schema in a database. This location will serve as the repository for your Iceberg tables within the catalog. Iceberg catalogs group tables into namespaces, which can be nested within other namespaces. The Iceberg specification supports arbitrary levels of nesting.

   For example, a SALES table could be defined within a STORES namespace, which is defined in a RETAIL namespace, which is itself defined within a CORPORATE namespace. The Iceberg location of such a table would be CORPORATE.RETAIL.STORES.SALES.

CREATE OR REPLACE CATALOG INTEGRATION tabular_catalog_int
  CATALOG_SOURCE = ICEBERG_REST
  TABLE_FORMAT = ICEBERG
  CATALOG_NAMESPACE = 'default'
  REST_CONFIG = (
    CATALOG_URI = 'https://api.tabular.io/ws'
    CATALOG_NAME = '<tabular_warehouse_name>'
  )
  REST_AUTHENTICATION = (
    TYPE = OAUTH
    OAUTH_TOKEN_URI = 'https://api.tabular.io/ws/v1/oauth/tokens'
    OAUTH_CLIENT_ID = '<oauth_client_id>'
    OAUTH_CLIENT_SECRET = '<oauth_secret>'
    OAUTH_ALLOWED_SCOPES = ('catalog')
  )
  ENABLED = TRUE;

1. On the Catalog page, select Manage Catalog. Click +Add.
2. On the Add Catalog dialog, select Iceberg catalog from the Catalog source tab.
   
   
   
   Description of the illustration add-catalog-iceberg.png
   
   

   Click Next.

3. Specify the following field values on the Catalog source tab of the Add Catalog dialog:

   • Catalog name: Enter the name of the Catalog you want to mount the Iceberg Catalog as.

     For example, Polaris.

   • Iceberg catalog type: Select Polaris from the drop-down field.

   • Iceberg catalog endpoint: It specifies your Polaris Catalog account URL. The endpoint for Snowflake's Polaris Catalog is usually in the format of https://<account_locator>.snowflakecomputing.com/polaris/api/catalog. For more information about account identifier formats, see the Snowflake documentation.
   • Iceberg catalog credential: Select a credential from the list of available credentials in the drop-down list. If you do not have a credential, you can create one. Select Create Credential. On the Create Credential dialog, specify the following field values:
     • Credential Name: Enter the name of your credential. For example, POLARIS_CRED.
       Under Get New Bearer Token,

       • Access token end point: Enter the Iceberg REST specification endpoint. This generates access token using OAuth2 defined as /v1/oauth/tokens.

         This endpoint was designed to facilitate authentication by exchanging client credentials (client ID and secret) for an access token.

         Note
         
         The /v1/oauth/tokens endpoint is deprecated in Iceberg version 1.6.0 and will be removed in version 2.0. You are encouraged to rely on external OAuth2 providers instead. See OAuth Authentication for more details.
       • Grant type: Select Client credentials.
       • Client ID: Specify the Client ID.
       • Client Secret: Specify the Client Secret.
       • Scope: PRINCIPAL_ROLE:ALL.

         Click Get Token.

         The Bearer token field gets populated.

       Click Create Credential.

       POLARIS_CRED is displayed as Iceberg catalog credential.

       
       
       
       Description of the illustration create-credential-polaris.png
       
       
       Note
       
       

       The credentials are stored using the procedure DBMS_CLOUD.CREATE_CREDENTIAL in the backend.

       For the sample example provided above, the procedure would be as follows:

       BEGIN
         dbms_cloud.create_credential( 
           credential_name  =>  'POLARIS_CRED',
           username         =>  'BEARER_TOKEN',
           password         =>  '<BEARER_TOKEN_VALUE This is generated using token endpoint, client id, client secret>'
         );
       END;

     
     
     
     Description of the illustration add-polaris-catalog-source.png
     
     

     This credential allows the Oracle Autonomous Database to access the Iceberg table.

   • Bucket credentials: This credential stores a cloud storage volume to store your Iceberg tables in Parquet format. This field is mandatory for Polaris catalogs.

     Click Next to proceed to the Iceberg catalog tab.

4. On the Iceberg catalog tab, you can specify the following field values:

   • Iceberg catalog namespaces: This field displays the hierarchical organization of tables. The Iceberg catalog endpoint consists of the root namespace. Select the namespace on which you want to have the catalog mounted.
   • Namespace separator style: Select Polaris style. This is the default value. Select any value based on the way your catalog is configured.
     Note
     
     It is preferred that you retain the default value.
   • Bucket region: Enter the bucket region. For example, us-west-2.

     Iceberg catalog endpoints, serve as interfaces for managing Iceberg tables stored in cloud storage like S3. The bucket region refers to the geographical location where the S3 bucket is hosted.

     This is mandatory field for Polaris catalogs.

     
     
     
     Description of the illustration namespace-polaris.png
     
     

   Click Add.

   After you have successfully mounted a new catalog over an Iceberg Catalog, you can view the Polaris Catalog on the Manage Catalogs page. You can disable and delete the catalog from this page.

   
   
   
   Description of the illustration manage-polaris-catalogs.png
   
   

1. On the Catalog tool, click Select Catalogs....
2. Click POLARIS _CATALOG filter on Catalogs and Schemas wizard to display the POLARIS_CATALOG catalogs.
3. Click Apply to view the results on the Catalog page.
   
   
   
   Description of the illustration catalogs-schemas-polaris-catalog.png
   
   

1. On the Catalog page, select Manage Catalog. Click +Add.
2. On the Add Catalog dialog, select Iceberg Catalog.
   
   
   
   Description of the illustration add-catalog-iceberg.png
   
   
3. Click Next.
4. Specify the following field values on the Catalog source tab of the Add Catalog dialog:
   • Catalog name: Enter the name of the Catalog you want to mount the Iceberg Catalog as.

     For example, Unity.

   • Iceberg catalog type: Select Unity from the drop-down field.
   • Iceberg catalog endpoint:

     For Unity Catalog, you typically use the Databricks REST API. The endpoint for accessing Iceberg tables via Unity Catalog is usually in the format of https://<databricks-instance-url>/api/2.1/unity-catalog/iceberg.

     Note
     
     See https://docs.databricks.com/aws/en/external-access/iceberg for more information.
   • Iceberg catalog credential: Select a credential from the list of available credentials in the drop-down list. If you do not have a credential, you can create one. Select Create Credential.
     On the Create Credential dialog, specify the following values:

     • Credential Name: Enter the name of your credential. For example, UNITY_CRED.
     • Bearer Token: Paste the Bearer Token value.

       Select Create Credential.

       UNITY_CRED is displayed as Iceberg catalog credential.

     
     
     
     Description of the illustration add-unity-catalog.png
     
     

     Click Next to proceed to Iceberg catalog tab.

     On the Iceberg catalog tab, you can specify the following field values:

   • Iceberg catalog namespaces: Select any one of the schemas you need access to.
   • Namespace separator style: The namespace separator style typically refers to how namespaces are structured and separated within the catalog. By default, Databricks style is selected.
   • Bucket region: This field is not mandatory.
     
     
     
     Description of the illustration iceberg-unity-catalog.png
     
     

     Click Add.

     
     
     
     Description of the illustration manage-unity-catalogs.png
     
     

   After you have successfully mounted a new catalog over an Iceberg Catalog, you can view the Unity Catalog on the Manage Catalogs page. You can disable and delete the catalog from this page.

1. On the Catalog tool, click Select Catalogs….
2. Click UNITY _CATALOG filter on the Catalogs and Schemas wizard to display the UNITY_CATALOG catalogs.
   
   
   
   Description of the illustration catalogs-schemas-unity-catalog.png
   
   
3. Click Apply to view the results on the Catalog page.
   
   
   
   Description of the illustration manage-catalogs-unity.png