Connect Snowflake to Crush
Give Crush governed access to Snowflake’s 8 tools through Runlayer, with identity, policy, scanning, and audit on every call.
Set up
Add Snowflake to Crush in four steps
Admins approve the server once. Everyone in Crush then gets it through the same governed connection.
- 1
Approve Snowflake in Runlayer
Add Snowflake from the catalog and choose who can use it and which of its tools are allowed.
- 2
Connect Crush to Runlayer
Users add the Runlayer Plugin to Crush by following Runlayer’s setup guide. Crush reaches Snowflake’s 8 tools through the Runlayer Plugin’s search and execute tools instead of listing each one.
Crush setup guide - 3
Sign in to Snowflake
Each user signs in to Snowflake with OAuth. Runlayer keeps the tokens out of the client’s configuration.
- 4
Use Snowflake from Crush
Snowflake’s approved tools appear in Crush. Every call is checked against policy and recorded.
Tools
8 Snowflake tools in Crush
Runlayer policy decides which of these Crush users can call.
Describe semantic view
Describe a semantic view.
Get semantic view ddl
Get the DDL for a semantic view.
List semantic views
List all semantic views in the account, database, or schema.
Query semantic view
Writes and runs a statement to query a semantic view using DIMENSIONS, METRICS, and/or FACTS.
Run Snowflake query
Run a SQL query in Snowflake.
Show semantic dimensions
Show all semantic dimensions in the account, database, or schema.
Show semantic metrics
Show all semantic metrics in the account, database, or schema.
Write semantic view query tool
Writes a query statement to query a semantic view using DIMENSIONS, METRICS, and/or FACTS.
Control
What Runlayer can see and stop in Crush
Some controls apply to every client at the gateway. Others depend on what Crush exposes to Runlayer.
Gateway policy (available)
Every Snowflake call from Crush passes through Runlayer, where your policies can allow, alert, mask, or block it.
Audit trail (available)
Each call is recorded with the user, Crush as the client, the tool, and the policy and scanner decisions.
Native enforcement adapter (not available)
Runlayer has no device-side adapter for Crush yet, so control happens at the gateway.
Frequently asked questions
Connect more