snowflake_query
Run SQL queries against Snowflake and receive results in YAML format. Authentication is handled by the omni-dev daemon with browser-based SSO.
Instructions
Run SQL against Snowflake and return the result set as YAML. Mirrors omni-dev snowflake query. The query runs through the omni-dev daemon, which multiplexes authenticated (account, user) sessions — so the daemon must be running (omni-dev daemon start). First-time use of an (account, user) authenticates via external-browser SSO on the daemon host (a browser may open there). account/user default to SNOWFLAKE_ACCOUNT/SNOWFLAKE_USER (and settings.json) when omitted; warehouse/role/database/schema are optional per-query context.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SQL to execute. Required. | |
| role | No | Per-query role (`USE ROLE`). | |
| user | No | Authenticating user. Falls back to `SNOWFLAKE_USER` / settings.json. | |
| schema | No | Per-query schema (`USE SCHEMA`). | |
| socket | No | Control-socket path override. Defaults to the per-user runtime location. | |
| account | No | Target account. Falls back to `SNOWFLAKE_ACCOUNT` / settings.json. | |
| database | No | Per-query database (`USE DATABASE`). | |
| warehouse | No | Per-query warehouse (`USE WAREHOUSE`). |