Skip to content
Snowflake · Native integration

Monitor Snowflake metrics.
Get pinged when they move.

Connect Lighthouse to Snowflake in minutes with read-only credentials. Describe any business metric in plain English. Get Slack alerts the moment something anomalous happens.

Connect Snowflake
  • Free forever tier
  • Read-only access
  • No credit card

Lighthouse watches your business metrics in Snowflake and alerts your team in Slack when one moves. Connect a read-only service account, describe a metric in plain English, and Lighthouse writes the Snowflake SQL, sets adaptive thresholds, and posts alerts with the current value, baseline and segment.

Transaction volume

US · Web

Snowflake
1,204-42%

Transaction volume triggered

Value1,204
Baseline2,080
SegmentUS · Web

Snowflake tells you what happened. Lighthouse tells you when to care.

Cost monitoring tools watch your Snowflake spend. Lighthouse watches your business metrics.

Cost tools watch spend, not metrics

CloudZero, Bluesky, and Snowflake's own dashboards tell you about credit usage and query costs, not whether your transaction volume dropped 40% this morning.

Engineering can't keep up with alerting requests

Every time a PM or analyst needs a new alert, it's a ticket. Engineers build it once, then it breaks silently when schemas change. Teams stop asking.

BI dashboards are reactive

Looker and Tableau show you what happened, when you look. Nobody is watching every dashboard every hour. Critical drops sit undetected until the weekly review.

From Snowflake to Slack alert in 10 minutes.

  1. 01

    Connect Snowflake

    Enter your account identifier and a read-only service account. Lighthouse never writes to Snowflake or copies your tables. Done in 3 clicks.

  2. 02

    Describe your metric

    Type something like 'transactions volume, last 3 hours' or 'checkout conversion rate, weekly.' Lighthouse writes the Snowflake SQL and configures adaptive thresholds automatically.

  3. 03

    Get pinged in Slack

    When the metric drops beyond your threshold, Lighthouse fires a Slack alert with the current value, baseline, compare period, and segment: everything your team needs to act.

Built for analysts, not just engineers.

Every feature is designed so your data team can set up and manage monitoring without filing a ticket.

Read-only Snowflake connector
Connect with a read-only service account in 3 clicks. Lighthouse never writes to Snowflake or copies your tables.
Natural language → SQL
Describe a metric like 'transactions in the last 3 hours' and Lighthouse writes the Snowflake SQL automatically, including CTEs, window functions, and time filters.
Adaptive thresholds
Lighthouse learns your week-over-week and day-of-week patterns, so it only alerts when something genuinely moved, not when Tuesday is slower than Monday.
Rich Slack alerts
Every alert includes the current value, baseline, threshold, compare period, and segment, so your team has full context without opening a dashboard.
Segment breakdowns
Monitor the same metric across segments (US vs EU, new vs returning users, mobile vs web) and get alerted only when a specific slice breaks.
Works on any table or view
Point Lighthouse at any Snowflake table, view, or materialized view. No pre-built connectors or schema requirements.
Read-only Snowflake connector
CREATE ROLE lighthouse_monitor;
GRANT USAGE ON WAREHOUSE your_warehouse
  TO ROLE lighthouse_monitor;
GRANT USAGE ON DATABASE your_db
  TO ROLE lighthouse_monitor;
GRANT USAGE ON SCHEMA your_db.your_schema
  TO ROLE lighthouse_monitor;
GRANT SELECT ON ALL TABLES IN SCHEMA your_db.your_schema
  TO ROLE lighthouse_monitor;

Checkout conversion rate

Snowflake
2.1%-38%

Checkout conversion rate triggered

Value2.1%
Baseline3.4%
16 of our analysts use Lighthouse daily to monitor the metrics that drive our products. It's become the layer that sits between our warehouse and our stand-ups.

Analytics Lead

A leading gaming company · 50M+ users · Snowflake

Common questions

What's the easiest way to connect Slack to Snowflake?
Snowflake's native route means writing SQL ALERT objects, configuring a notification integration, and calling SYSTEM$SEND_SNOWFLAKE_NOTIFICATION by hand, with no baseline learning, so you tune static thresholds yourself. Lighthouse replaces that: connect with a read-only service account, describe the metric in plain English, and alerts post straight to Slack with adaptive baselines built in.
Do I need to share Snowflake admin credentials?
No. Lighthouse only requires a read-only service account. We recommend creating a dedicated role with SELECT permissions on the schemas you want to monitor, nothing more.
How is this different from Snowflake's native alerts?
Snowflake's native alerts are SQL-only and have no baseline learning or seasonality awareness. Lighthouse adds AI-powered threshold detection, Slack delivery, and lets non-technical analysts define metrics in plain English.
What business metrics can Lighthouse monitor?
Any metric that can be expressed as a SQL query: transaction volume, DAU, revenue per session, conversion rates, error rates, signups, churn signals, and more. If it's in Snowflake, Lighthouse can watch it.
How long does setup take?
Most teams connect Snowflake and create their first metric in under 10 minutes. No engineering ticket required.
Can multiple analysts share the same Lighthouse workspace?
Yes. Lighthouse is built for teams. Analysts can each manage their own metrics and alerts, all connected to the same Snowflake instance.

Start monitoring your Snowflake metrics today.

Free forever for small teams. Connect in under 10 minutes.

Connect Snowflake

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