Configure a catalog integration for Polaris Catalog

The example on this page demonstrates how to create a catalog integration for Polaris Catalog, which you can use to query a table in Polaris Catalog using Snowflake or sync a Snowflake-managed table with Polaris Catalog. For more information, see Use Snowflake Iceberg tables with Polaris Catalog.

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

To create a catalog integration for Polaris Catalog, use the CREATE CATALOG INTEGRATION (Polaris Catalog) command.

CREATE OR REPLACE CATALOG INTEGRATION my_polaris_int
  CATALOG_SOURCE = POLARIS
  TABLE_FORMAT = ICEBERG
  CATALOG_NAMESPACE = 'myPolarisCatalogNamespace'
  REST_CONFIG = (
    CATALOG_URI = 'https://myAccount.snowflakecomputing.com/polaris/api/catalog'
    WAREHOUSE = 'myPolarisExternalCatalogName'
  )
  REST_AUTHENTICATION = (
    TYPE = OAUTH
    OAUTH_CLIENT_ID = 'myClientId'
    OAUTH_CLIENT_SECRET = 'myClientSecret'
    OAUTH_ALLOWED_SCOPES = ('PRINCIPAL_ROLE:ALL')
  )
  ENABLED = TRUE;
Copy
Language: English