Configure a catalog integration for Snowflake Open Catalog¶

Create a catalog integration for Snowflake Open Catalog, which you can use to query a table in Snowflake Open Catalog using Snowflake or sync a Snowflake-managed table with Open Catalog. For more information, see Use Apache Iceberg™ tables with Snowflake Open Catalog in Snowflake.

A catalog integration for Open Catalog is associated with a specific catalog and service connection in your Open Catalog account.

To create a catalog integration for Open Catalog, use the CREATE CATALOG INTEGRATION command.

CREATE OR REPLACE CATALOG INTEGRATION my_open_catalog_int
  CATALOG_SOURCE = POLARIS
  TABLE_FORMAT = ICEBERG
  CATALOG_NAMESPACE = 'myOpenCatalogCatalogNamespace'
  REST_CONFIG = (
    CATALOG_URI = 'https://<orgname>-<my-snowflake-open-catalog-account-name>.snowflakecomputing.com/polaris/api/catalog'
    WAREHOUSE = 'myOpenCatalogExternalCatalogName'
  )
  REST_AUTHENTICATION = (
    TYPE = OAUTH
    OAUTH_CLIENT_ID = 'myClientId'
    OAUTH_CLIENT_SECRET = 'myClientSecret'
    OAUTH_ALLOWED_SCOPES = ('PRINCIPAL_ROLE:ALL')
  )
  ENABLED = TRUE;

• To find your Snowflake organization name (<orgname>), follow the steps in Finding the organization and account name for an account.

• To find <my-snowflake-open-catalog-account-name, see Find the account name for a Snowflake Open Catalog account in the Snowflake Open Catalog documentation.

• If you’re syncing a Snowflake-managed table with Open Catalog, specify CATALOG_NAMESPACE = 'default'.