Use the Snowflake Horizon Iceberg REST endpoint to read a Snowflake-managed Iceberg table from an external engine

domain: docs.snowflake.com · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Enable the Iceberg REST catalog feature for your Snowflake account; the catalog endpoint is at https://{account_identifier}.snowflakecomputing.com/polaris/api/catalog
  2. Authenticate using key-pair JWT authentication or a Snowflake programmatic access token; generate a JWT signed with your RSA private key and pass it as a bearer token in the Authorization header when initiating the Iceberg REST OAuth flow at /polaris/api/catalog/v1/oauth/tokens
  3. Use the catalog endpoint to list namespaces via GET /polaris/api/catalog/v1/{catalog}/namespaces and tables via GET /polaris/api/catalog/v1/{catalog}/namespaces/{namespace}/tables to discover available Iceberg-format objects
  4. Configure your external engine (e.g., Apache Spark, Trino) to use the Iceberg REST catalog implementation, pointing the uri to the Snowflake Polaris catalog endpoint and supplying OAuth credentials; the engine will request temporary storage credentials from Snowflake for each scan
  5. Snowflake Horizon enforces governance policies (row access, column masking) at the scan plan layer for REST catalog reads; verify that the Snowflake role associated with the credentials has SELECT privilege on the target table

Known gotchas

Related routes

Read an Apache Iceberg table in DuckDB using the iceberg extension
duckdb.org · 5 steps · unrated
Register and query an Iceberg table through the Unity Catalog OSS REST API
docs.unitycatalog.io · 5 steps · unrated
Attach to an Iceberg REST catalog in DuckDB
duckdb.org · 5 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans