Skip to content
ClickRuntime

Automate Snowflake

Keep an eye on warehouse credit spend, send query results to people who don't log in to Snowsight, and catch loads that didn't arrive. ClickRuntime runs SQL against your account through the SQL API with a role you choose. Describe what you want to your AI assistant, check what it will do, and it keeps running.

Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Try asking

Create a ClickRuntime automation: every morning at 7, check Snowflake warehouse credit usage for the last 24 hours and email me any warehouse that used more than 10 credits.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Ideas

What you can automate in Snowflake

Credit spend alerts before the bill surprises you, query results in your inbox each morning, and a warning when a table stops getting new rows. These are ready-made starting points. Anything else you can describe works too.
Daily

Get an email when a warehouse uses too many credits

Each morning you learn which warehouses used more than your limit in the last 24 hours.

See how it works
Daily

Email a KPI query's results every morning

The numbers you'd otherwise open Snowsight for arrive as a table in your inbox.

See how it works
Hourly

Get a Slack alert when a table gets no new rows

If today's load hasn't arrived by 9am, your data channel hears about it once.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Snowflake, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Snowflake automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what Snowflake should do in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Every morning, check Snowflake credit usage per warehouse and warn me if any warehouse used more than 150% of its 7-day average yesterday.

Every Monday at 8am, run my weekly revenue query in Snowflake and post the result table with a short AI summary of what changed to our #finance Slack channel.

Every day, run a Snowflake query for customers whose usage dropped by half this month, add them to a Google Sheets tracker, and create a HubSpot task for each account owner.

Beyond chat

Have Snowflake work when you're not in the chat

Connecting Snowflake to ChatGPT or Claude lets you ask about it while you chat. ClickRuntime handles the part that should happen on its own: checks on a schedule and actions on each new event, set up from the same chat and running after you close it.

Setup

Connect Snowflake

Snowflake connects with a programmatic access token (PAT) you create for your own Snowflake user, restricted to a role you pick. Key-pair authentication works for service users.

Snowflake

Data warehouse

  1. In Snowsight, open Governance & security, then Users & roles, and select the user the automation should run as.
  2. Choose Generate new token, give it a name, set the expiry and restrict it to a role that can read the tables you need. You can also run ALTER USER ... ADD PROGRAMMATIC ACCESS TOKEN in SQL.
  3. Copy the token secret straight away; Snowflake shows it only once.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the token and your account identifier as a Snowflake secret.

Good to know

Snowflake limits that affect automations

  • Access tokens expire, and an admin sets the longest lifetime allowed. Expiry can't be extended, so create a new token and update the secret before the old one runs out.
  • Your account's network and authentication policies decide whether a token can be used. Check them with your Snowflake admin before connecting.
  • Every query runs on one of your warehouses and uses its credits, so an hourly check costs more than a daily one.
  • Credit usage reports need a role that can read the ACCOUNT_USAGE views.

FAQ

Questions about automating Snowflake

What can ClickRuntime see in Snowflake?
Only what the token's role can see. Restrict the token to a role with read access on the tables or views your automations query; ClickRuntime runs the SQL you agree to and nothing else.
What happens when my token expires?
Queries stop working until you add a new one. Create a new token in Snowsight and replace the secret in the ClickRuntime dashboard; the automations keep their settings.
Will these automations use warehouse credits?
Yes. Every query runs on a warehouse you choose. Small count and summary queries use little, but checking every hour adds up, so pick a schedule that fits.
Can I use key-pair authentication instead of a token?
Yes, for service users. You generate an RSA key pair, set the public key on the user with `ALTER USER ... SET RSA_PUBLIC_KEY`, and ClickRuntime signs short-lived tokens with the private key.
Do I need AI for Snowflake automations?
No. These run SQL and compare numbers. If you want results explained in plain English, that uses the AI that comes with every ClickRuntime plan, so you don't need your own AI key.
Is this a Snowflake connector for ChatGPT or Claude?
Not for chatting with Snowflake data. A chat connector lets your assistant read and change Snowflake while you're in the conversation. ClickRuntime is for the work that should happen without you: you set up an automation from the chat once, and it keeps running on a schedule or on each Snowflake event.

Related pages

Keep exploring

Tell your assistant what Snowflake should do

Free plan. No credit card.

Add to ChatGPTAdd to Claude