Get up and running with cost optimization, real-time query suspension, security compliance scoring, and autonomous agents in your Snowflake account.
When you launch the Streamlit App for the first time from your Snowflake workspace, you will be greeted by the interactive Setup Wizard. This guide ensures your current user environment is compatible.
The wizard automatically checks if your active session role has the required schema access. It detects the active warehouse and verifies if there is a running cluster to load catalog metadata.
Cortex AI functions are required for natural language query explanation. The wizard tests model availability (e.g. llama3-8b) in your Snowflake region, showing warning alerts if access is restricted.
With a single click on "Initialize Database Schemas", SnowOps automatically creates necessary operational tables (like DBT_MODEL_REGISTRY and QUERY_BENCHMARK) to hold historical run statistics.
Runaway queries and zombie warehouses can deplete your Snowflake credits rapidly. The Cost Guardian module provides active budget protection rules.
Review the warehouse grid to see which warehouses have auto-suspend set to "Never" or excessively high limits. Set these to 60-120 seconds for standard dev/test environments.
The system uses statistical Z-scores of hourly credits to determine spikes. A spike exceeding 3.0 standard deviations is flagged as a CRITICAL anomaly, prompting Slack notifications.
Identify slow-running queries and click the "Suspend Query" button. SnowOps compiles a safe SYSTEM$ABORT_QUERY('query_id') request to kill the task instantly.
Admins can manually kill queries or suspend idle warehouses directly using these native Snowflake commands:
SnowOps integrates with Snowflake Cortex LLMs, enabling you to explain slow-performing queries, receive rewriting recommendations, and chat with your database structure.
Navigate to the "AI Power Suite". Paste any complex SQL query. The system queries Cortex to decompose the query into a simple, non-technical bulleted summary.
Request a rewrite aimed at either minimizing cost or maximizing execution speed. Cortex rewrites standard joins to use partition pruning and prunes unused columns.
Upload your semantic YAML model to the stage using SnowSQL. This metadata allows users to chat and generate database queries dynamically.
Keep track of your dbt tasks, raw streams, and dynamic data pipeline runs directly from the monitoring dashboard.
Inspect multi-level task chains. The system maps the root tasks to child tasks using the AFTER dependency configuration to display execution sequences.
Monitor dbt model statuses (SUCCESS, FAIL, RUNNING) inside the registry. Drill down into failed task logs to find compilation or permission issues.
Observe Stream action metrics (like INSERT checks and METADATA$ACTION values) to see if source data is loading into core tables.
The dbt model registry table captures model runs and allows you to view duration trends across warehouses:
Maintain corporate data governance and audit trails using automated security compliance scorecards.
The scorecard audits the number of active users, checking if multi-factor authentication (MFA) is enabled for high-privilege roles like ACCOUNTADMIN.
The dashboard scans for active network policies, ensuring database endpoints are restricted to whitelisted enterprise IP ranges.
Identify columns containing sensitive data (e.g. emails, phone numbers, SSNs). Create automated masking rules to redact data for lower-tier roles.
Reach out to our core developer queue for support, custom integrations, or bug reports.
Open Support Hub →