Snowflake
Snowflake-managed MCP server for Cortex Analyst, Cortex Search, and SQL over your data warehouse
Ways to connect
2 ways to connect Snowflake
Every one of them gets the same identity, policy, scanning, and audit. Pick the delivery and sign-in that fit your workspace.
Runlayer-hosted, read-only SQL
- Delivery
- Built and hosted by Runlayer
- Sign-in
- Authentication varies
- Tools
- 8
Tools
8 available tools
Search the tool definitions captured from the MCP server. The live list can vary with version, deployment, and credentials.
8 tools found.
Describe semantic view
Tool name:
describe_semantic_viewDescribe a semantic view.
Get semantic view ddl
Tool name:
get_semantic_view_ddlGet the DDL for a semantic view.
List semantic views
Tool name:
list_semantic_viewsList all semantic views in the account, database, or schema.
Query semantic view
Tool name:
query_semantic_viewWrites and runs a statement to query a semantic view using DIMENSIONS, METRICS, and/or FACTS.
Run Snowflake query
Tool name:
run_snowflake_queryRun a SQL query in Snowflake.
Show semantic dimensions
Tool name:
show_semantic_dimensionsShow all semantic dimensions in the account, database, or schema.
Show semantic metrics
Tool name:
show_semantic_metricsShow all semantic metrics in the account, database, or schema.
Write semantic view query tool
Tool name:
write_semantic_view_query_toolWrites a query statement to query a semantic view using DIMENSIONS, METRICS, and/or FACTS.
Compatibility
Connect Snowflake to the clients your teams already use
27 AI clients can connect to Snowflake through Runlayer. Pick one for its setup steps and controls.
Why Runlayer
Why connect Snowflake through Runlayer?
One approved path
Approve Snowflake once and everyone gets it in the AI clients they already use. Runlayer holds the credentials, so nothing sits in client configuration.
Fine-grained policy
Control who can use each server, tool, and resource, and under which runtime conditions.
Runtime security
Scan tool inputs and outputs for prompt injection, credential exposure, PII, and data exfiltration, then alert, mask, or block.
Audit and observability
Trace every request across users, clients, tools, policies, scanner decisions, and downstream systems.
