SnowOps Intelligence — Platform Screenshots & Features

[01] DASHBOARD OVERVIEW

Command Center

Your operational headquarters. KPI cards for credits, efficiency scores, warehouse health, and data freshness — all at a glance.

Main Dashboard

Total credits, daily burn rate, efficiency score, active alerts, failed queries, and top warehouse — all updated in real time with one-click refresh.

streamlit_app.py → Home

Sidebar Navigation

Intelligence Hub, AI Power Suite, and Operations modules — organized for fast access to every feature.

19+ modules

Platform Settings

Configure telemetry, PostHog keys, warehouse defaults, and refresh intervals from the admin panel.

settings.py

[02] COST INTELLIGENCE

Credit Visibility & Attribution

15 sub-tabs covering overview, warehouse metering, ingestion, user and role attribution, anomaly detection, dbt models, and forecasting.

Credit Usage by Warehouse

Donut chart and horizontal bar chart showing credit distribution across all warehouses. Interactive tooltips reveal exact credit counts.

1_cost.py → By Warehouse

Cost by Role

Attribute credit consumption to specific Snowflake roles. Identify which roles drive the most compute spend.

1_cost.py → By Role

Cost by User

User-level credit attribution with query counts and estimated costs. Track individual consumption patterns.

1_cost.py → By User

Ingestion Tracking

Monitor data loading costs across pipes and stages.

1_cost.py → Ingestion

Deep Dive Attribution

Sankey flow diagram: Compute → Warehouse → User credit mapping.

1_cost.py → Deep Dive

Anomaly Detection

Hourly credit consumption with anomaly zones. Z-score based burst detection with CRITICAL/WARNING severity levels.

1_cost.py → Anomalies

Scenario Forecasting

Monthly budget runway projections using planned or pessimistic consumption rates.

1_cost.py → Forecast

[03] COST GUARDIAN

Burst Detection & Protection

Real-time monitoring of credit burn rates with automatic anomaly flagging. Kills runaway workloads before they drain your budget.

Live Warehouse Status

Credits today, credits last hour, active warehouses, auto-suspend configs, and per-warehouse credit/hour burn rates in a real-time table.

1_cost.py → Cost Guardian

[04] QUERY PERFORMANCE

Workload Intelligence

Top workloads, query attribution, slow query analysis, failed queries, and storage intelligence.

Top Workloads (7d)

Ranked workloads by volume with average duration, user count, and warehouse mapping. Identifies the most resource-intensive operations.

2_queries.py

Query Intelligence

Pattern analysis and optimization recommendations.

2_queries.py → Intelligence

Query Attribution

Map query costs to users, roles, and warehouses.

1_cost.py → Query Attribution

Slow Queries

Identify and analyze the slowest running queries.

2_queries.py → Slow

Failed Queries

Track error patterns and failure rates across workloads.

2_queries.py → Failed

[05] WAREHOUSE OPS

Cluster Health & Optimization

Warehouse health scores, auto-suspend tuning, benchmark savings calculations, and cold asset detection.

Warehouse Health Optimizer

Health score per warehouse (higher = healthier). Color-coded bar chart from green (healthy) to yellow (needs attention). Average health score and total credits overview.

1_cost.py → Warehouse Optimizer

Warehouse Metrics

Detailed per-warehouse performance metrics and utilization.

warehouse_ops.py

Benchmark Savings

Calculate potential credit savings from optimization.

warehouse_ops.py → Savings

Cold Asset Detection

Identify unused tables, schemas, and warehouses consuming storage without active queries.

data_observability.py

[06] AI POWER SUITE

Cortex AI, Agents & BI Builder

Natural language analytics, autonomous agent builder, AI/BI dashboard creation, and SQL workbench.

Cortex AI Analyst

Cost Flow Analysis — visualize how credits flow from total budget to individual warehouses using Sankey diagrams. Ask questions in plain English.

3_cortex.py

AI Analytics Wizard

Automated analysis and visualization generation from natural language prompts.

cortex.py → Wizard

AI Wizard — Results

Generated charts and SQL from conversational queries.

cortex.py → Results

Agent Builder

Create autonomous agents with RAG knowledge bases, guardrails, and governance controls. Agents run as Snowflake Tasks.

agent_builder.py

AI/BI Dashboard Builder

No-code dashboard assembly with drag-and-drop metric components.

4_builder.py

SQL Workbench

Built-in SQL editor with syntax highlighting, execution, and result visualization — directly inside the Streamlit app.

sql_workbench.py

[07] SECURITY & GOVERNANCE

CIS Benchmarks & PII Scanner

Automated compliance scoring, PII column detection, login forensics, and user risk assessment.

CIS Compliance Scorecard

Security grade based on CIS Snowflake Foundations Benchmark. Score deductions shown with actionable recommendations. Account admins, network policies, and active users at a glance.

security_governance.py → Scorecard

User Risk Scorecard

Per-user security scoring with privilege analysis.

security → Users

Enforcement Audit

Track policy enforcement actions and compliance status.

security → Audit

[08] ALERTS & MONITORING

Real-Time Notifications

Slack and Teams webhook integrations, custom alert rules, and monitoring dashboards.

Alerts Dashboard

Active alerts, triggered rules, and monitoring status overview.

alerts.py

Alert Rules

Configure custom thresholds and notification channels.

alerts.py → Rules

Webhook Configuration

Connect Slack, Teams, or custom API endpoints for automated notifications.

alert_agent.py → Webhooks

Data Observability

Monitor data freshness, pipeline health, and schema changes.