Start free
ActionSnowflakeUpdated June 2026

How do I run a Snowflake SQL query?

Short answer: You can snowflake execute sql in Snowflake by hand from its own interface, but it won’t repeat itself. On TinyCommand, add the Snowflake Snowflake Execute SQL action to a workflow, map its 1 input from any upstream app, and it runs automatically every time the trigger fires. No code, and a free tier to start.

Snowflake Execute SQL in Snowflake — start free All 1 Snowflake actions
Snowflake Execute SQL in Snowflake — start free
Inputs

The fields this action accepts.

Every field can be mapped from an upstream trigger, AI step, table row, or hard-coded literal.

FieldTypeRequiredDescription
SQL Statement
statement
stringRequiredSQL Statement. e.g. "SELECT * FROM my_table LIMIT 10"
Sample request
{
  "statement": "SELECT * FROM my_table LIMIT 10"
}
Returns
{
  "data": [
    [
      1,
      "John",
      "john@example.com"
    ]
  ],
  "statementHandle": "stmt123",
  "resultSetMetaData": {
    "numRows": 1,
    "rowType": [
      {
        "name": "ID"
      },
      {
        "name": "NAME"
      },
      {
        "name": "EMAIL"
      }
    ]
  }
}

Use these fields in downstream nodes for routing, logging, or error handling.

Triggered by

Apps that pair well as the trigger for Snowflake Execute SQL.

Any of these apps can fire this action as part of a workflow.

Gmail → Snowflake
1 Gmail triggers
Slack → Snowflake
13 Slack triggers
Google Sheets → Snowflake
2 Google Sheets triggers
HubSpot → Snowflake
18 HubSpot triggers
FAQ

Questions about Snowflake Execute SQL.

What does the Snowflake Execute SQL action do in Snowflake?
Executes a SQL query against Snowflake. Compute cost = warehouse-size × runtime, so tight queries on partitioned columns save real money. For nightly KPI rollups or for ad-hoc BI reports.
What inputs does Snowflake Execute SQL require?
Required: SQL Statement. Every input accepts a static value or a variable from any upstream node in your workflow.
Can I use dynamic inputs from earlier workflow nodes?
Yes. Any field on this action can pull values from upstream nodes, whether that's a form response, a trigger payload, an AI output, or a lookup result.
What happens if Snowflake returns an error?
The workflow pauses on the failed node, the error message is captured in the run log, and you can retry the run with one click. Auto-retry policies are configurable per workflow with exponential backoff up to 5 attempts.
Does Snowflake Execute SQL support batch operations?
Yes. Run Snowflake Execute SQL inside a Loop node to process arrays. TinyCommand handles Snowflake's rate limits automatically so you don't have to throttle manually.
Snowflake Execute SQL in Snowflake — start free