SnowLens is a Streamlit app that installs directly into your Snowflake account. It analyses your query performance and cost patterns using your own account metadata — nothing is ever sent outside your environment.
SnowLens reads only Snowflake's own metadata views. Your data never leaves your account, ever.
Runs on Streamlit-in-Snowflake, which is built into every Snowflake account. Nothing to deploy.
Trial features never expire. Use Slow Query Finder and Cost Anomaly Detector as long as you need.
One SQL script removes every object SnowLens created. No residue, no lock-in.
The trial edition includes two fully working detection rules, running on the same detection engine as the full version. No time limit, no account required, no card needed.
Flags any query — successful or failed — that takes longer than 10 seconds of total elapsed time. Runs continuously on a rolling 6-hour window, so you catch slow queries as they happen instead of digging through yesterday's history.
Compares each warehouse's hourly credit consumption to its own rolling 7-day average. Flags any hour where usage spikes more than 2 standard deviations above baseline — catching runaway queries, forgotten warehouses, or unexpected batch jobs before they balloon your bill.
Most observability tools require sending your query logs to an external SaaS. SnowLens is different by design.
Queries ACCOUNT_USAGE.QUERY_HISTORY and WAREHOUSE_METERING_HISTORY — Snowflake's own internal views about how your account is used, not your actual business tables.
Streamlit-in-Snowflake runs in an isolated environment. SnowLens makes no calls to external APIs, analytics services, or the VizCanvaz servers.
The app runs on a warehouse in your account. You pay your own Snowflake compute cost (typically a few cents per session on an XS warehouse).
The installer creates a dedicated SNOWLENS_ROLE with only the permissions the app needs. It cannot write to your data or access objects outside its own schema.
Three steps. All done inside Snowsight. No CLI, no cloud console, no infrastructure.
Download the ZIP from the button below. It contains two SQL scripts and two Python source files. No other dependencies.
↓ Download SnowLens TrialOpen a new Snowsight worksheet as ACCOUNTADMIN. Paste and run sql/01_setup.sql. This provisions a dedicated warehouse, database, stage, and role — nothing touches your existing objects.
In Snowsight, navigate to Data → Databases → SNOWLENS_TRIAL → APP → Stages → SNOWLENS_STAGE and upload streamlit_app.py and environment.yml from the src/ folder. Then run sql/02_create_app.sql.
Done. Open Projects → Streamlit → SNOWLENS_APP in Snowsight. The app loads with both trial features ready.
The trial never expires — use it as long as you need. When you're ready for deeper visibility, the full edition adds 6 more anomaly detectors and longer data windows.
SNOWFLAKE.ACCOUNT_USAGE schema — Snowflake's own internal metadata about query history and warehouse usage. It does not query any of your business tables, and it does not have visibility into the actual content of your queries beyond what Snowflake stores in ACCOUNT_USAGE (query text snippets, timing, credit consumption).sql/99_uninstall.sql as ACCOUNTADMIN. It drops the SNOWLENS_TRIAL database, SNOWLENS_WH warehouse, and SNOWLENS_ROLE in three lines. Every object SnowLens created is gone with no residue.Download the trial ZIP, run two SQL scripts in Snowsight, and you're live.
Your data stays inside your account — always.
Questions? Email vizcanvas@gmail.com