Snowflake Integration
Monitor warehouse credit usage, query queue times, and storage costs across your Snowflake account. AI-powered cost anomaly detection before your bill surprises you.
How It Works
Create a Monitoring Service Account
Create a Snowflake service account with MONITOR privilege on the ACCOUNT_USAGE schema. TigerOps uses this to query performance and billing views without any write access.
Configure the TigerOps Snowflake Connector
In TigerOps Settings > Integrations > Snowflake, enter your account identifier, service account credentials, and the warehouses to monitor. Polling begins immediately.
Set Credit Budget Alerts
Define daily and monthly credit budget thresholds per warehouse. TigerOps fires alerts when actual consumption approaches your budget with a projected end-of-month forecast.
Monitor Query Performance
TigerOps surfaces long-running queries, high spillage queries, and queuing times per warehouse. Correlate performance regressions with schema changes or new query patterns.
What You Get Out of the Box
Credit Usage Tracking
Per-warehouse credit consumption with hourly granularity, daily totals, and month-to-date aggregates. Compare credit burn rates across warehouses and over time.
Query Queue Monitoring
Track query queuing time per warehouse and identify when auto-scaling kicks in. Correlate queue spikes with specific user roles, query types, or application load.
Storage & Transfer Costs
Monitor Snowflake storage bytes, data transfer volumes, and compute-to-storage cost ratios. Identify tables with excessive replication or staging data growth.
Long-Running Query Detection
Surface queries exceeding your configured duration threshold. Get the query text, execution plan statistics, bytes spilled, and user information attached to the alert.
Warehouse Auto-Suspend Tracking
Monitor warehouse active/suspended state transitions, idle time before auto-suspend, and credit waste from frequent resume cycles on poorly configured warehouses.
AI Cost Anomaly Detection
TigerOps AI detects unusual credit consumption patterns — weekend spikes, off-hours warehouse activity, and sudden query volume increases — and fires alerts before costs escalate.
Snowflake Account Monitoring Config
Set up the TigerOps service account and configure warehouse credit budgets.
-- snowflake-tigerops-setup.sql
-- Create a read-only monitoring role for TigerOps
CREATE ROLE IF NOT EXISTS tigerops_monitor;
-- Grant access to ACCOUNT_USAGE views (billing + performance)
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE tigerops_monitor;
-- Grant MONITOR privilege for warehouse status
GRANT MONITOR ON ALL WAREHOUSES IN ACCOUNT TO ROLE tigerops_monitor;
GRANT MONITOR USAGE ON ACCOUNT TO ROLE tigerops_monitor;
-- Create the service account user
CREATE USER IF NOT EXISTS tigerops_agent
PASSWORD = '<strong-random-password>'
DEFAULT_ROLE = tigerops_monitor
DEFAULT_WAREHOUSE = COMPUTE_WH
MUST_CHANGE_PASSWORD = FALSE;
GRANT ROLE tigerops_monitor TO USER tigerops_agent;
-- tigerops-snowflake.yaml — TigerOps connector config
# integrations:
# snowflake:
# account: myorg-myaccount
# user: tigerops_agent
# password: "${SNOWFLAKE_PASSWORD}"
# role: tigerops_monitor
# warehouse: COMPUTE_WH
# pollInterval: 5m
#
# budgets:
# - warehouse: PROD_ANALYTICS_WH
# dailyCreditLimit: 100
# monthlyCreditLimit: 2000
# - warehouse: ETL_WH
# dailyCreditLimit: 50
# monthlyCreditLimit: 800
#
# alerts:
# longRunningQueryThresholdSeconds: 300
# highSpillThresholdGB: 10
# queueTimeThresholdSeconds: 60Common Questions
What Snowflake permissions does TigerOps require?
TigerOps requires MONITOR privilege on the account and USAGE privilege on the SNOWFLAKE database ACCOUNT_USAGE schema for billing and performance views. No write permissions are required. A minimal read-only service account is sufficient.
How does TigerOps access Snowflake account usage data?
TigerOps queries the SNOWFLAKE.ACCOUNT_USAGE views (QUERY_HISTORY, WAREHOUSE_METERING_HISTORY, STORAGE_USAGE, etc.) on a configurable polling interval. Data is typically available in ACCOUNT_USAGE with a 45-minute latency.
Can TigerOps alert on per-user or per-role credit consumption?
Yes. TigerOps can group credit consumption by user, role, or query tag. Set per-user credit thresholds to prevent runaway ETL jobs or interactive analytical sessions from consuming unexpected resources.
Does TigerOps support Snowflake Snowpark metrics?
Yes. Snowpark Python and Java queries appear in QUERY_HISTORY with their execution statistics. TigerOps treats them identically to SQL queries for performance monitoring and credit accounting.
Can TigerOps integrate with Snowflake Budget objects?
Yes. TigerOps can read Snowflake Budget objects (available in Enterprise and higher editions) and fire alerts when budget thresholds are approached, providing a unified view of both Snowflake-native and TigerOps budget tracking.
Stop Discovering Snowflake Cost Overruns After Invoice Day
Credit budget alerts, query performance monitoring, and AI cost anomaly detection for Snowflake.