Snowflake
Monitoring Kit · v2

12 metrics. Every Snowflake
account. One setup.

Every Snowflake account has the same ACCOUNT_USAGE schema. These 12 metrics turn it into live alerts with smart comparison — each one checks against a 30-day rolling baseline so you only get paged when something is genuinely wrong.

Start monitoring free →
Free forever for small teamsRead-only accessNo migrationNo credit card
12
Production-ready metrics
4
Categories covered
30-day
Smart comparison baseline
10 min
From connect to first alert
Snowflake Kit · 12 metrics · Live
MetricCategorySchedule
Warehouse Credit Spike — Last 24h
CostHourly
Total Credits Spike — Yesterday
CostDaily
Database Storage Spike — Last 7d
CostDaily
Failsafe Storage Spike — Last 7d
CostDaily
AI And Other Services Credits Spike
CostDaily
Long-Running Queries — Last 1h
PerformanceHourly
Query Queue Anomaly — Last 3h
PerformanceHourly
Remote Disk Spill Anomaly — Yesterday
PerformanceDaily
ETL Failure Rate Spike — Last 4h
FailuresHourly
Failed Task — Last 1h
FailuresHourly
Stale Tables — 90-Day No Query
OptimizationWeekly
Warehouse Utilization — Yesterday
OptimizationDaily

Permissions

1 read-only grant. That's it.

Lighthouse only reads metadata — query history, metering stats, storage usage. It cannot access your actual table data, run DML, create objects, or modify anything.

ACCOUNT_USAGE Access

One-time grant. Every metric on this page runs on this single grant — no per-warehouse or per-account MONITOR privileges needed.

GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE <your_role>;
  • Query history
  • Task history
  • Warehouse metering history
  • Storage history
  • Serverless & AI service costs
  • Table metadata
  • New users, tables & warehouses — auto-included forever

Read-only, always → This grant is a SELECT-only metadata privilege. Run it once and you're done — new warehouses, users, tables, and activity are automatically covered. Lighthouse cannot write data, drop tables, create warehouses, or access the contents of your tables — only operational metadata like query durations, credit consumption, and storage sizes.

How it works

We configure it. You get the alerts.

01

Connect Snowflake

Read-only credentials, 3 clicks. Lighthouse reads your schema — never your raw data. Takes under 5 minutes.

02

Deploy the kit

All 12 monitoring metrics go live in your Lighthouse workspace — pre-configured, pre-tuned, with 30-day smart comparison baselines. No SQL required.

03

Get Slack alerts

When cost spikes, queries fail, or warehouses misbehave, you get a Slack message with value, baseline, and context — before anyone has to ask.

Time windows explained → Every metric reads from ACCOUNT_USAGE with a -1h lag, so every check lands on data that's had time to settle. No partial reads, no false drops.

💰

Cost & Credits

5 metrics
01 / COSTReal-timeHourly

Warehouse Credit Spike — Last 24h

Why monitor

  • Warehouse compute is usually the single biggest line on the Snowflake bill — a spike here hits budget before finance even notices.
  • Tells you exactly which workload is responsible — ETL, BI, or ad-hoc — instead of just knowing that spend is up somewhere.
  • Catches runaway warehouses within the hour — a stuck query, a misconfigured auto-suspend, a bad loop — before a full day of waste piles up.
02 / COSTHistoricalDaily

Total Credits Spike — Yesterday

Why monitor

  • Catches death-by-a-thousand-cuts spend — five services each a little over their own baseline won't trip any single alert, but together they move this number.
  • One number for the whole account — rolls up warehouse compute, serverless tasks, and AI/Cortex spend so nothing slips through between individual metrics.
  • The first thing worth checking each morning — a stable number means nothing needs digging into; a spike tells you exactly where to look next.
03 / COSTHistoricalDaily

Database Storage Spike — Last 7d

Why monitor

  • Storage is billed every month forever, whether the data is useful or not — a growth spike becomes a permanent addition to the bill unless someone catches it early.
  • Tells you which database is responsible before it turns into a shared, hard-to-untangle cost across teams.
  • A bad pipeline can quietly add terabytes in days — by the time it shows up on the invoice, the cost is already locked in.
04 / COSTHistoricalDaily

Failsafe Storage Spike — Last 7d

Why monitor

  • Failsafe is mandatory and non-negotiable — you can't turn it off or shrink it after the fact, so growth here is locked-in extra cost.
  • Usually signals a fixable engineering habit — a pipeline recreating large tables instead of updating them incrementally.
  • Easy to miss since it doesn't show up in normal storage dashboards — often the quiet reason a storage bill runs higher than expected.
05 / COSTHistoricalDaily

AI And Other Services Credits Spike

Why monitor

  • Serverless tasks and Cortex AI features bill outside any warehouse — invisible until the bill arrives if nobody's watching per-service spend.
  • Segmented per service so nothing gets buried — a spike in AI agent usage won't be masked by normal auto-clustering or query acceleration activity.
  • AI and Copilot usage is the fastest-growing, least-visible cost category right now — this is usually the first place runaway AI spend shows up.

Performance

3 metrics
06 / PERFReal-timeHourly

Long-Running Queries — Last 1h - Over 30 Minutes

Why monitor

  • A single runaway query can burn as many credits as hundreds of normal ones — every extra minute is warehouse capacity and money being consumed.
  • Often the first sign of a regression — a schema change, a join that used to be cheap, or a workload that outgrew its warehouse.
  • Users stuck waiting on a slow dashboard or pipeline rarely file a ticket right away — this catches the problem before someone complains.
07 / PERFReal-timeHourly

Query Queue Anomaly — Last 3h

Why monitor

  • Queued queries mean people are waiting — dashboards load slowly and pipelines run late, with no error message, just frustration.
  • Persistent queuing is a capacity signal — it's telling you to scale up or split the workload before it becomes a recurring complaint.
  • Catches contention early, before an important report or exec dashboard is the one stuck behind everything else.
08 / PERFHistoricalDaily

Remote Disk Spill Anomaly — Yesterday

Why monitor

  • Remote spill is 10–100× slower than in-memory processing — a spilling query burns disproportionately more credits and time for the exact same result.
  • Usually means a warehouse is undersized for its workload — a clear, fixable signal instead of a vague 'things feel slow' complaint.
  • Left unnoticed, this is pure waste: same output, worse performance, higher bill.

Want Slack alerts when any of these fire?

Connect Snowflake to Lighthouse in 10 minutes — free, read-only, no SQL required.

Start free →
🔴

Failures

2 metrics
09 / FAILReal-timeHourly

ETL Failure Rate Spike — Last 4h

Why monitor

  • A failed pipeline means stale or missing data downstream — dashboards and reports quietly go wrong with no obvious sign anything broke.
  • Failure rate, not raw count, tells you when something is actually broken — versus normal background noise from a handful of ad-hoc errors.
  • Pipeline breakage is usually invisible until a stakeholder notices bad numbers — by then, decisions have already been made on bad data.
10 / FAILReal-timeHourly

Failed Task — Last 1h

Why monitor

  • Tasks fail silently by default — no email, no Slack — so stale downstream data can go unnoticed for days.
  • A failed nightly transform means every report built on top of it is wrong until someone happens to catch it.
  • An immediate error message means you know right away whether it's a dependency issue, a schema change, or a data problem — not a scramble to diagnose from scratch.
⚙️

Optimization

2 metrics
11 / OPTAuditWeekly

Stale Tables — 90-Day No Query

Why monitor

  • Every table nobody queries is pure cost with zero value — you're paying storage for data that isn't helping anyone.
  • Some of these tables are still being ingested into daily even though nobody reads them — wasted pipeline maintenance and compute on data nobody needs.
  • A prioritized cleanup list, sorted by staleness and storage size, makes it easy to cut costs and shrink the number of objects you have to maintain or worry about in an audit.
12 / OPTHistoricalDaily

Warehouse Utilization — Yesterday

Why monitor

  • Low utilization means you're paying for a warehouse that's mostly sitting idle — a clear signal to downsize or tighten auto-suspend.
  • High utilization means queries are likely queueing behind each other — a capacity risk before it turns into a performance complaint.
  • Turns warehouse sizing from a guess into a decision — right-size for cost without guessing at performance risk.

Want Slack alerts when any of these fire?

Connect Snowflake to Lighthouse in 10 minutes — free, read-only, no SQL required.

Start free →

Live in Lighthouse

Real alerts, running right now

LH
LighthouseAPP

⚠️ Warehouse Credit Spike — COMPUTE_WH used 12.4 credits in the last 24h. 30-day max: 3.1 credits · 4× above baseline.

LH
LighthouseAPP

⚠️ Total Credits Spike — Account spent 142 credits yesterday. 30-day max: 98 credits · 1.4× above baseline.

LH
LighthouseAPP

⚠️ Database Storage Spike — ANALYTICS_DB averaged 18.2 GB over the last 7 days. 30-day weekly max: 3.1 GB · 5.9× above baseline.

LH
LighthouseAPP

⚠️ Failsafe Storage Spike — ANALYTICS_DB: 94 GB in failsafe. 30-day weekly max: 23 GB · Tables with frequent overwrites are driving retention costs.

LH
LighthouseAPP

⚠️ AI And Other Services Credits Spike · *Service*: CORTEX_CODE_SNOWSIGHT · *Credits*: 84.3 · *Compared to*: 11.2 · *Threshold*: 13.4

LH
LighthouseAPP

⚠️ Long-Running Query — 3 queries exceeded 30 min in the last hour. Longest: 47 min on ANALYTICS_WH by user ETL_SERVICE.

LH
LighthouseAPP

⚠️ Query Queue Anomaly — 18% of queries queued on REPORTING_WH in the last 3 hours. 30-day same-time average: 4% · Consider scaling up or splitting the workload.

LH
LighthouseAPP

⚠️ Remote Disk Spill — 12.4 GB spilled to remote storage yesterday. 30-day max: 0.3 GB · TRANSFORM_WH queries are undersized for this workload.

LH
LighthouseAPP

⚠️ ETL Failure Rate Spike — 23% failure rate in the last hour (7 of 30 ETL queries failed on ETL_WH). 7-day max: 2% · Check recent schema changes.

LH
LighthouseAPP

⚠️ Failed Task — NIGHTLY_TRANSFORM failed at 2:14 AM (scheduled 2:00 AM). Error: SQL compilation error — object 'STAGE_DB.RAW.EVENTS' does not exist.

LH
LighthouseAPP

🔍 Stale Tables Audit — 12 tables with no access in 90+ days. Total: 142 GB. Largest: LEGACY_EVENTS (89 GB) in ANALYTICS_DB.

LH
LighthouseAPP

⚠️ Low Warehouse Utilization — TRANSFORM_WH: 12% utilization yesterday. Only 0.3 of 2.5 compute credits went to actual queries · Consider reducing warehouse size or lowering auto-suspend.

LH
LighthouseAPP

⚠️ Warehouse Credit Spike — COMPUTE_WH used 12.4 credits in the last 24h. 30-day max: 3.1 credits · 4× above baseline.

LH
LighthouseAPP

⚠️ Total Credits Spike — Account spent 142 credits yesterday. 30-day max: 98 credits · 1.4× above baseline.

LH
LighthouseAPP

⚠️ Database Storage Spike — ANALYTICS_DB averaged 18.2 GB over the last 7 days. 30-day weekly max: 3.1 GB · 5.9× above baseline.

LH
LighthouseAPP

⚠️ Failsafe Storage Spike — ANALYTICS_DB: 94 GB in failsafe. 30-day weekly max: 23 GB · Tables with frequent overwrites are driving retention costs.

LH
LighthouseAPP

⚠️ AI And Other Services Credits Spike · *Service*: CORTEX_CODE_SNOWSIGHT · *Credits*: 84.3 · *Compared to*: 11.2 · *Threshold*: 13.4

LH
LighthouseAPP

⚠️ Long-Running Query — 3 queries exceeded 30 min in the last hour. Longest: 47 min on ANALYTICS_WH by user ETL_SERVICE.

LH
LighthouseAPP

⚠️ Query Queue Anomaly — 18% of queries queued on REPORTING_WH in the last 3 hours. 30-day same-time average: 4% · Consider scaling up or splitting the workload.

LH
LighthouseAPP

⚠️ Remote Disk Spill — 12.4 GB spilled to remote storage yesterday. 30-day max: 0.3 GB · TRANSFORM_WH queries are undersized for this workload.

LH
LighthouseAPP

⚠️ ETL Failure Rate Spike — 23% failure rate in the last hour (7 of 30 ETL queries failed on ETL_WH). 7-day max: 2% · Check recent schema changes.

LH
LighthouseAPP

⚠️ Failed Task — NIGHTLY_TRANSFORM failed at 2:14 AM (scheduled 2:00 AM). Error: SQL compilation error — object 'STAGE_DB.RAW.EVENTS' does not exist.

LH
LighthouseAPP

🔍 Stale Tables Audit — 12 tables with no access in 90+ days. Total: 142 GB. Largest: LEGACY_EVENTS (89 GB) in ANALYTICS_DB.

LH
LighthouseAPP

⚠️ Low Warehouse Utilization — TRANSFORM_WH: 12% utilization yesterday. Only 0.3 of 2.5 compute credits went to actual queries · Consider reducing warehouse size or lowering auto-suspend.

Common questions

Will this be another dashboard my team has to check?

No — the kit doesn't add a dashboard to your routine. It watches these 12 metrics in the background and only shows up in Slack when one of them actually fires. Nothing new to check unless there's something worth knowing.

Do I need to write or tune any SQL?

No. All 12 metrics are pre-built and pre-tuned with 30-day baseline comparison out of the box. Connect your account and they go live as-is — you can adjust thresholds later if you want, but nothing is required.

What if we already have Snowflake cost alerting set up?

This kit covers more than cost — failures, performance, and optimization too — and layers on top of anything you already have. If some metrics overlap with existing alerts, just skip deploying those and keep the rest.

How is this different from Snowflake's own resource monitors?

Resource monitors are budget caps — they suspend a warehouse when spend crosses a hard limit. This kit alerts you before that point, with a 30-day baseline so you catch a spike early instead of hitting a wall.

These metrics are running in Lighthouse right now

Want alerts when any
of these fire?

Connect your Snowflake account and get all 12 metrics live in under 10 minutes — free, read-only, with smart comparison out of the box.

Already have metrics in mind? Describe them in plain English — Lighthouse writes the SQL.

No credit card required · Read-only access · Cancel anytime