Skip to content
Amazon Redshift · Connects through Postgres

Monitor Redshift metrics.
Get Slack alerts automatically.

Connect Lighthouse to Amazon Redshift in minutes. Describe a business metric in plain English, and get pinged in Slack the moment it moves, no Lambda functions, no cron jobs.

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

Daily active users

Redshift
8,410-25%

Daily active users triggered

Value8,410
Baseline11,210

CloudWatch monitors your cluster. Nobody's watching what's inside it.

Amazon CloudWatch tracks Redshift infrastructure health. It won't tell you when your daily active users dropped 25% or why revenue stalled.

Wiring Redshift → Slack takes a full sprint

EventBridge + Lambda + Redshift Scheduled Queries + Slack webhooks is a real architecture. It works until a Lambda cold-start breaks it silently and nobody notices.

Every new business metric is an engineering ticket

When a product manager wants to track signups by cohort, they file a ticket. Engineers deprioritize it. The metric goes unwatched.

Static alerts cry wolf

Percentage thresholds that don't know about weekends, holidays, or campaign spikes fire constantly. Teams tune them out, until the one real drop goes unnoticed.

From Redshift to Slack alert in 10 minutes.

  1. 01

    Connect Redshift

    Add your Redshift endpoint and read-only credentials. Lighthouse scans your schemas, surfaces tables and views, and is ready to monitor in minutes.

  2. 02

    Describe your metric

    Type 'daily active users this week vs last week' or 'checkout errors in the last hour.' Lighthouse writes the Redshift SQL and configures adaptive baselines automatically.

  3. 03

    Get pinged in Slack

    When your metric moves past its threshold, Lighthouse fires a Slack alert with current value, baseline, percentage change, segment, and compare period: full context in one message.

Everything your team needs. Nothing they don't.

Connects through the Postgres connector

Connect with a read-only database user in minutes. Lighthouse reads your schema metadata and generates optimized queries, no manual configuration.

Handles Redshift-specific SQL

Lighthouse generates production-grade Redshift SQL including window functions, LISTAGG, distribution-aware queries, and late-binding views.

Day-of-week baseline learning

Lighthouse learns your weekly patterns and compares Tuesday to the last 4 Tuesdays, not yesterday. Fewer false positives without any threshold tuning.

Rich Slack alerts

Every alert includes current value, baseline, percentage change, threshold, compare period, and segment. Full context, no dashboard required.

Works on any Redshift cluster

Provisioned clusters and Redshift Serverless both supported. Connect multiple clusters to a single Lighthouse workspace.

No ongoing maintenance

When your schema changes, Lighthouse adapts. No stale cron jobs, no broken Lambda functions, no on-call alerts about the alerting system itself.

Common questions

What's the easiest way to connect Slack to Redshift?
Most teams build this by hand: EventBridge on a schedule, a Lambda function running a Redshift Scheduled Query, then posting to a Slack webhook, and maintaining it when the Lambda cold-starts or the query breaks. Lighthouse replaces the whole pipeline: connect with a read-only database user, describe the metric in plain English, and alerts post straight to Slack.
What credentials does Lighthouse need for Redshift?
A read-only database user with SELECT permissions on the schemas you want to monitor. We recommend creating a dedicated Lighthouse user; nothing with write access is needed.
Does Lighthouse work with Redshift Serverless?
Yes. Lighthouse supports both provisioned Redshift clusters and Redshift Serverless. You connect using the same read-only credentials.
How is this different from Amazon CloudWatch?
CloudWatch monitors Redshift infrastructure: query performance, disk usage, connection counts. It has nothing to say about your business KPIs. Lighthouse monitors the data inside Redshift: transactions, DAU, revenue, conversions, and sends Slack alerts when they change.
What business metrics can Lighthouse monitor from Redshift?
Any metric expressible as a SQL query: transaction volume, DAU, revenue, conversion rates, signups, churn signals, error rates, and more. If it lives in Redshift, Lighthouse can watch it.
How long does setup take?
Most teams connect Redshift and create their first metric in under 10 minutes. No engineering ticket required.

Start monitoring your Redshift metrics today.

Free forever for small teams. Connect in under 10 minutes. No Lambda functions to build.

Connect Redshift

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