Snowflake Open Catalog

Snowflake Open Catalog is an Iceberg REST Catalog, managed by Snowflake.

Cloud Provider Support

An existing Snowflake Open Catalog, with proper permissions configured. Follow this guide from Snowflake.

Snowflake Open Catalog can be used as the primary catalog in Spark and SQL Clusters.
Clusters using Snowflake Open Catalog will automatically install Apache Iceberg version 1.10.0.

Snowflake Open Catalog currently cannot be used to sync Onehouse tables to Snowflake via the Metadata Sync table service. Instead, use the Snowflake Horizon Catalog for metadata syncs.
Catalog events (such as table creation) will not be registered to Onehouse.
Tables created with IRC cannot run table services.

In the Onehouse console, open Catalogs, then click Add New Catalog. Fill in the following configurations.

Name: Unique identifier for the data catalog in Onehouse. This does not need to match the catalog name in Snowflake.
Type: Select 'Snowflake Open Catalog'.
Account ID: Enter the account ID for your Snowflake Open Catalog.
- Depending on the region and cloud platform for your account, this identifier might be the account locator by itself (for example, xy12345) or include additional segments. For more information, see the official Snowflake docs on using an account locator as an identifier.
Catalog Name: Enter a name that your Clusters will use to identify the catalog.
- In your code and SQL, you can reference tables as <catalog-name>.<database>.<table> or simply <database.table>.
Region (optional): Specify the region ID for the catalog's Snowflake account.
Principal Role Name: Specify the name of the principal role for the catalog in Snowflake.

Enter the following credentials from Snowflake in your catalog setup.

Client ID: Enter the Client ID from your Snowflake Open Catalog connection.
Client Secret: Enter the Client Secret from your Snowflake Open Catalog connection.

Coming Soon!