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 using Snowflake or sync a Snowflake-managed table with Polaris. For more information, see Use Snowflake Iceberg tables with Polaris Catalog.
A catalog integration for Polaris is associated with a specific catalog and service connection in your Polaris account.
To create a catalog integration for Polaris, 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;