What it does
Snowflake runs SQL statements via the v2 SQL REST API. Uses api_key auth with a Personal Access Token (PAT) — Snowflake's HTTP-friendly auth.
Setup
- In Snowflake → Admin → Users & Roles → [your user], create a Programmatic Access Token (PAT).
- Note your account locator (e.g.
xy12345.us-east-1). - In FlowFn, go to Platform Tools → Snowflake → Connect and provide account + api_key (PAT).
Actions
- Run Query (sync), Get Query Status (async poll), Cancel Query
Notes
PAT is sent as Authorization: Bearer + X-Snowflake-Authorization-Token-Type: PROGRAMMATIC_ACCESS_TOKEN. Queries exceeding the sync timeout return a statementHandle for polling.