19+ built-in dashboards for automated cost intelligence, latency optimizations, warehouse auto-sleep configurations, and Cortex AI analytics. Deployed as a secure Native App — your metadata and query history never leave your Snowflake security boundary.
Explore high-fidelity telemetry, analytics workspaces, and auto-sleep guards compiled directly within your Snowsight console frame.
Ask operational metadata metrics in standard plain English, and have local Cortex LLMs build query blueprints automatically.
Attribute credit consumption down to precise tags, query roles, specific DBT models, and direct user warehouses.
Unveil partition skew, map cross join bottlenecks, identify Cartesian operations, and receive instant indexing recommendations.
Audit network policies, analyze MFA adoption rate metrics, scan catalogs for un-encrypted column assets, and compile scores.
Harness secure, local LLMs natively integrated into Snowflake. Query database catalog assets using conversational English, run automated JOIN path analysis to find query bottlenecks, and track dbt run credits row-by-row.
Enforce operational boundaries. Instantly detect query cost anomalies with configurable credit thresholds. Automatically apply optimized warehouse suspend limits to clusters that remain idle, saving credit runways in real-time.
A unified developer and financial operations monitor designed to identify credit leakage, trace inefficient join paths, and scan database architectures inside your Snowflake account.
15 sub-tabs covering overview, specific warehouses, ingestion tracking, roles, dbt cost attribution, anomalies, and forecasting.
Free & Open SourceWorkload duration tracking, relational join analyzer, query pattern aggregation, partition skew maps, and scan recommendations.
Free & Open SourcePer-warehouse projections utilizing custom models. Calculate monthly runways using planned or pessimistic consumption rates.
Free & Open SourceReal-time burst and anomalous query spike shutdown limits. Automatically kills runaway workloads before credit depletion.
Free & Open SourceNatural language metadata interface worksheet. Instantly compile correct SQL worksheets and chart telemetry patterns.
Free & Open SourceNo-code relational metric builder tools. Drag and drop components to assemble high-fidelity operational dashboards instantly.
Free & Open SourceInstantiate autonomous system agents inside your account boundary to run automated alert scripts to Slack or Teams channels.
Free & Open SourceRun full CIS Snowflake Foundation audits inside Snowflake. Automated database regex scanner filters and identifies sensitive PII columns.
Free & Open SourceAutomated computing cluster health metrics, cluster auto-suspend policy optimizations, and sizing recommendations.
Free & Open SourceEvery single advanced optimization, artificial intelligence dashboard, and automated SRE agent script is fully functional and included in the repository.
| Functional Modules | Dashboard Script & Context File | License & Availability Status |
|---|---|---|
| Cost Intelligence (1_cost.py) | ||
| Cost Overview & Burn Metrics | pages/1_cost.py [tab_overview] | ✓ Included (Free & Open Source) |
| Warehouse Metering breakdowns | pages/1_cost.py [tab_metering] | ✓ Included (Free & Open Source) |
| User & Role attribution | pages/1_cost.py [tab_attribution] | ✓ Included (Free & Open Source) |
| Runaway query spike (Cost Guardian) | setup/setup_git_deploy.sql [RUN_BUDGET_CHECK] | ✓ Included (Free & Open Source) |
| Query Performance (2_queries.py) | ||
| Relational join query analyzer | pages/2_queries.py [plan_tree] | ✓ Included (Free & Open Source) |
| Workload duration statistics | pages/2_queries.py [metrics_dashboard] | ✓ Included (Free & Open Source) |
| AI Observability & SRE Automation | ||
| Cortex AI Worksheet Assistant | pages/3_cortex.py [llm_worksheet] | ✓ Included (Free & Open Source) |
| No-code Custom Dashboard visual builder | pages/4_builder.py [drag_drop_assembler] | ✓ Included (Free & Open Source) |
| SRE Slack / Teams Notification Alert agent | app/alert_agent.py [slack_webhook_daemon] | ✓ Included (Free & Open Source) |
| CIS Security & Column PII Scanner | setup/setup_git_deploy.sql [DQ_SCAN_RESULTS] | ✓ Included (Free & Open Source) |
SnowflakeOps structures optimization across 5 isolated modular execution layers. By operating directly inside Streamlit-in-Snowflake, each engine can perform deep audits on system logs securely.
Read Architecture DocsStreams and parses raw Snowflake query history records, mapping relational execution trees, filtering sub-optimizations, and charting join performance curves instantly.
Monitors clustering factors and tracks compute warehouses staying active without executing queries. Recommends ideal scale up/down timings and auto-suspend variables to optimize usage.
Scans queries to identify heavily repeated datasets. Generates automated advise scripts to build secure materialized views or force Snowflake result caching to avoid compute spend.
Evaluates account configurations against standard CIS Snowflake benchmarks. Automatically flags open network policies, over-privileged users, and runs database column scanning to tag sensitive PII.
Maps warehouse compute charges directly down to individual query tags, users, dbt models, and role clusters. Provides clear projections on monthly budget runways and billing anomalies.
A high-contrast interactive view representing real-time telemetry pipelines and security audits running inside your Snowflake database.
Zero external infrastructure to manage. You can deploy the entire application directly from GitHub without cloning the repository or installing CLI tools. Copy and run directly inside your worksheet context.
Log into Snowsight. Open a clean SQL worksheet in your Snowflake console and
execute your administrator role context to initialize secure privileges:
USE ROLE ACCOUNTADMIN;
Copy the contents of the setup/setup_git_deploy.sql script shown in the code window, or directly from the GitHub Repository.
Paste it into the worksheet and click ▶ Run All. Navigate to Projects → Streamlit and launch the SNOWFLAKE_OPS_INTELLIGENCE app. You are fully live!
-- [01] ASSUME ADMIN STATUS
USE ROLE ACCOUNTADMIN;
-- [02] DEFINE SECURE REPOSITORY INTEGRATION
CREATE OR REPLACE API INTEGRATION git_api_integration
API_PROVIDER = git_https_api
API_ALLOWED_PREFIXES = ('https://github.com/devbysatyam')
ENABLED = TRUE;
CREATE OR REPLACE GIT REPOSITORY snowflake_ops_intelligence
API_INTEGRATION = git_api_integration
ORIGIN = 'https://github.com/devbysatyam/snowflake_ops_intelligence.git';
-- [03] SPIN UP STREAMLIT NATIVE DASHBOARD
CREATE STREAMLIT snowflake_ops_app
ROOT_LOCATION = '@snowflake_ops_intelligence/branches/main/app'
MAIN_FILE = 'streamlit_app.py'
QUERY_WAREHOUSE = 'COMPUTE_WH';
No tier gates, no credit limitations, no pricing traps. Get the complete suite of advanced cost tracking, Cortex AI assist, and autonomous cost guardians for absolute zero cost.
Deploy both our standard monitoring dashboards and our advanced Cortex AI & Cost Guardian engines natively inside your secure Snowflake perimeter. Apache 2.0 Licensed.
Need setup assistance? Visit our Support Hub or email support@aivon.io
Complete visibility covering Cost, Warehouses, dbt staging pipelines & anomalous spikes.
Secure natural language SQL converters & worksheet helper agents natively on your tables.
Autonomous auto-suspend timers, custom warehouse limits, and query timeout rules.
Real-time automated alerting webhooks to Slack channels, MS Teams & standard API targets.
Automated benchmark checklists, user roles hierarchy auditing & sensitive column scanner.
Apache 2.0 Open Source. Runs completely inside your secure Snowflake perimeter—zero data egress.
We prioritize dashboard modules and utility plug-ins based on community votes and direct requests. Trace our next milestones or submit custom ideas.
Submit your desired cost dashboard look, node structure, or automated suspension rules.
Aivon developers review security parameters, assuring zero external egress vectors.
Approved modules are published to the SnowOps GitHub repo for community usage.
All submissions are processed under strict privacy guidelines. Your request details are directly logged and evaluated by the Aivon engineering team.
Specify your requirements below and track real-time dev scheduling status.