Systems Management Associates

Data Warehouse & Analytics

Foglight for Snowflake

Cost, warehouses, and query performance

Description

Snowflake is a cloud-native data platform that separates storage and compute, letting teams spin up virtual warehouses on demand and pay for what they use. It powers analytics, data sharing, and machine-learning pipelines across enterprises that have standardized on a single SQL engine for the lakehouse.

Foglight for Snowflake polls Snowflake's account usage and performance views to bring warehouse activity, credit consumption, and query behavior into Foglight alongside your other database and platform monitors.

Business Challenge

Snowflake's native dashboards excel at a moment-in-time view of one account, but credit burn, warehouse queuing, and long-running queries can creep up unnoticed when no one is watching history or correlating signals across accounts. Finance and platform teams need proactive visibility before costs spike or SLAs slip.

Foglight for Snowflake treats the Snowflake account as a monitored resource, surfacing warehouse load, query latency, storage growth, and failed jobs with Foglight alerting and roll-up health.

Key Features

Foglight for Snowflake collects account usage metrics, warehouse utilization, query history summaries, and storage statistics through Snowflake's SQL interface. Connection details and credentials are agent properties configured on the Foglight Agent Manager.

Dashboards and rules focus on the signals operators care about: warehouse saturation, queuing, failed queries, credit consumption trends, and storage growth - with the Foglight Rules Engine alerting before analytics consumers feel the pain.

Screenshots

Snowflake Overview
Snowflake Overview
Warehouses
Warehouses
Queries
Queries
Storage
Storage
Resource Monitors
Resource Monitors
Cost Optimization
Cost Optimization

Ready to see Snowflake in action?

Request a free trial or talk to our engineers about your environment.