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://myAccount.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;