query_snowflake
Run read-only Snowflake queries using a pipeline’s configured connection, supporting SELECT, SHOW, and DESCRIBE; omit SQL to preview the destination table.
Instructions
Run a read-only query against the Snowflake account a pipeline loads into. Pass the pipeline name; the server resolves the account, credentials, warehouse, and role from the pipeline's config — same connection the loader uses, credentials never leave the server. Only works for pipelines whose destination is Snowflake (database with useSnowflake=true). Allowed statements: SELECT (WITH/CTE), SHOW, and DESCRIBE — LIMIT is auto-appended to SELECTs. Omit sql to preview the pipeline's destination table (the 'did my load land?' check). Metadata discovery uses the same tool — there are no separate list_snowflake_* tools: SHOW DATABASES, SHOW SCHEMAS IN DATABASE <db>, SHOW TABLES IN SCHEMA <db>.<schema>, DESCRIBE TABLE <db>.<schema>.<table>, or query .information_schema.columns. Queries run on the customer's configured warehouse (which costs them compute) — keep them targeted and let the default LIMIT stand unless the user asks for more.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"pipeline": "<pipeline>"
},
"name": "query_snowflake"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | Read-only statement: SELECT/WITH, SHOW, or DESCRIBE. Omit to preview the pipeline's destination table. | |
| limit | No | Maximum rows to return (default: 100). Pass -1 for unlimited. | |
| pipeline | Yes | Pipeline name (from list_pipelines). Must have a Snowflake destination. |