Snowflake Metrics Digest with Claude Code

Snowflake bills for every second the warehouse is awake, so this digest works through the list back to back and finishes as soon as the last result is in. Claude Code holds a long defined sequence without wandering off it, which here means it is not stopping to inspect a column halfway through with the warehouse still burning credits.
Loading preview…
Free to start · guided setup · switch agents any time.

Live demo

Watch it work before it's live

Run a staged conversation — no account needed. The agent handles it for real while a simulated world answers its tool calls; nothing touches real accounts, and nothing is actually sent.

Morning metrics 12 August

Ruben Castellanos, Analytics LeadANALYTICS_WH / RETAIL_MART

The warehouse resumed in four seconds and all five statements finished inside the same minute. Gross merchandise value came back at 812,440.20 MXN against 774,910.05 yesterday, orders at 3,188 against 3,050, returns at 214, and active stores at 61 with no change.

What you'll need

Set up in minutes

Using this template drops you into a guided setup. It asks exactly this, nothing else:

  1. Connect Snowflake

    One sign-in. The agent acts through your account, scoped to what this template uses.

  2. Connect Slack

    One sign-in. The agent acts through your account, scoped to what this template uses.

  3. Metrics queries

    The read only statements to run each morning, each with the name it should carry in the digest and its database and schema written out in full. Nothing outside this list is ever submitted to your warehouse.

  4. Digest style

    What the digest should look like when it lands - which metric leads, the movements worth flagging (weekly active accounts under 4,000, on time delivery under 90 percent), and who gets tagged when a statement fails.

  5. Runs on Claude Code

    Preselected for this page — connect your Claude Code account during setup, or switch to NoClick's built-in models with one click.

  6. Watch it handle a test run

    A staged conversation against a simulated world — then it’s live.

A considered pairing

Why Claude Code for this agent

Awake once, briefly

One window each morning instead of five people resuming a warehouse at five different times for five different numbers. The credits land in a single stretch you can size.

No side query while it runs

Nothing outside your statement list is submitted, including the curious little select that would explain what a column holds. That habit is what turns a two minute run into a ten minute one.

Good to know

Before you fork

How long does the warehouse stay awake for one digest?

As long as your slowest statement plus the polling between them, which for aggregates over summary views is usually a minute or two. An extra small warehouse with a short auto suspend is the sensible pairing. Cost is dominated by what your statements make the warehouse do, not by the agent reading results.

Other editions

Run it with a different agent

OpenAICodexopencodeopenclawhermesMore Claude Code agents

Make it yours

Put Snowflake Metrics Digest to work on Claude Code.

Free to start. Guided setup, a staged test run, and a workflow you can change at every step.