Snowflake IntegrationTurn your Snowflake investment into a system that drives understanding, action, and proven impact across your entire team.
You built your data foundation on Snowflake. KPI Tree adds the layer on top that your BI tools were never designed to provide. Map how metrics drive each other. Assign ownership to real people. Deliver personalised action plans. Prove what worked, statistically. Create metrics with SQL, or generate them from natural language using Cortex Analyst and your Semantic Views. One query per metric, all downstream analytics off-warehouse.
Connected in under an hour
A guided setup wizard generates the exact SQL you need. No agents to install, no data extraction, no firewall changes unless you choose to add them.
Run the generated setup SQL
The wizard generates copy-paste SQL that creates a dedicated user with RSA key-pair authentication, a least-privilege role with read-only grants, and an optional network policy scoped to KPI Tree's static IP. Review the SQL, paste it into a Snowflake worksheet, and run. Most teams create a dedicated XS warehouse to isolate costs.
Connect and validate
Provide your account identifier, warehouse, and RSA private key. KPI Tree validates the connection in real time. Snowflake supports two simultaneous public keys for zero-downtime rotation, and your private key is encrypted at rest.
Start building
Write SQL directly against your tables and views, or switch to Cortex mode and create metrics from plain English using your Semantic Views. From there, map how metrics drive each other, assign RACI ownership, and start closing the loop between data and action.
Deep integration with the Snowflake platform
KPI Tree uses Snowflake's platform capabilities natively - Cortex Analyst, Semantic Views, RSA key-pair auth, network policies. Your governance model stays exactly as your team configured it.
Cortex Analyst and Semantic Views
KPI Tree auto-discovers Semantic Views in your connected database. In Cortex mode, anyone can describe a metric in plain English. Cortex Analyst generates the SQL using your Semantic View as context, and the result appears in the editor for review. Cross-region inference is supported automatically.
One query per metric, off-warehouse analytics
Each metric syncs with one query on a configurable schedule. Comparison periods, correlations, regressions, and outlier detection all run in KPI Tree's compute engine without pushing additional queries to Snowflake.
Snowflake-native security
RSA key-pair authentication with no passwords stored. Network policies scoped to a single static IP. A dedicated role with only read-only grants. Governance inherited from your Snowflake configuration, not recreated.
Create metrics from natural language with Cortex Analyst.
Your Semantic Views describe your data in business terms. Cortex Analyst turns questions into SQL. KPI Tree connects both - the SQL editor includes a toggle between SQL and Cortex modes. Business users describe the metric they need in plain English, select a Semantic View, and Cortex generates the SQL. The generated SQL appears in the editor for review before execution. Every metric created this way gets the same ownership, causal context, and statistical monitoring as one written in SQL.
- Auto-discovers all Semantic Views in the connected database
- SQL editor toggles between SQL and Cortex modes
- Generated SQL appears for review before execution
- Cross-region inference supported automatically
Map cause and effect across your entire business.
Snowflake stores the data. KPI Tree reveals how it connects. Metric trees map how every KPI drives the ones above it - from operational inputs through to revenue outcomes. When a number moves, you can trace the tree to understand why. Assign RACI ownership to each metric so every driver has a named person accountable for it. Statistical correlation analysis surfaces relationships you might not have spotted. Root cause detection traces anomalies through the full tree automatically.
- Visual cause-and-effect trees built from your Snowflake data
- RACI ownership assigns accountability to real people
- Statistical correlation analysis surfaces hidden relationships
- Root cause detection traces anomalies through the tree
One query per metric. No additional queries for comparisons or aggregations.
KPI Tree runs one query per metric to sync data from Snowflake. Comparison periods, correlations, regressions, outlier detection, and causal analysis all run in KPI Tree's compute engine without pushing additional queries back to your warehouse. Every query generates a deep link back to Snowflake's query history so you can inspect what ran.
- No additional warehouse queries for comparisons or aggregations
- Dedicated XS warehouse keeps costs visible on your bill
- Dedicated XS warehouse recommended for cost isolation
- Deep links to Snowflake query history for every query
Security your team has already approved.
The setup wizard generates review-ready SQL that follows Snowflake security best practices. RSA key-pair authentication means no passwords are stored or transmitted. A network policy restricts access to a single static IP. A dedicated role gets only the grants it needs. Your existing Snowflake security posture stays exactly as configured.
- RSA key-pair authentication with zero-downtime key rotation
- Network policy scoped to a single static IP
- Least-privilege read-only role
- All credentials encrypted at rest
What KPI Tree adds that your BI tools do not
Your BI tools show you dashboards. KPI Tree closes the loop between seeing a metric and proving someone did something about it. That is the layer Snowflake was never designed to provide, and no dashboard tool has ever built.
Cause and effect, not just charts
Metric trees map how every KPI drives the ones above it. When revenue drops, you can trace the tree to find whether it was traffic, conversion, or average order value - and who owns each driver. No dashboard gives you that structure.
Ownership that creates accountability
Every metric has a named owner with full RACI. Actions are tracked against the metric they were meant to move. Personalised action plans tell each team member what to focus on. Impact is verified statistically, not self-reported.
Off-warehouse analytics that keep costs flat
One query per metric syncs data into KPI Tree's engine. Comparisons, correlations, regressions, and outlier detection all run off-warehouse. Your Snowflake bill stays predictable as your team grows.
Related integrations
Other data sources that work with KPI Tree.
Common questions
- SQL to create a dedicated user (RSA key-pair or password auth), a dedicated role with read-only grants, and optional network policy SQL scoped to KPI Tree's static IP. You review the full SQL before running it in a Snowflake worksheet.
- USAGE on your database, schemas, and warehouse. SELECT on tables, views, and semantic views (including future grants). That is the full grant surface.
- KPI Tree discovers Semantic Views in your database automatically. In Cortex mode, users type a natural-language description and select a Semantic View. Cortex Analyst generates the SQL using your Semantic View as context. The generated SQL appears in the editor for review before execution. Cross-region inference is supported automatically.
- One query per metric on a configurable schedule. All comparisons, correlations, and analysis run off-warehouse. We recommend a dedicated XS warehouse so costs are isolated . The warehouse auto-suspends between sync cycles.
- Yes. If you use dbt, see our dedicated dbt Cloud and dbt Core integration pages. One-click sync imports every metric, dimension, and time grain. Changes flow through automatically.
- Generate an RSA key pair and assign the public key to your KPI Tree user in Snowflake. Provide the private key in KPI Tree. Snowflake supports two simultaneous public keys for zero-downtime rotation. Your private key is encrypted at rest.
- A dedicated XS warehouse. KPI Tree runs one lightweight query per metric on a configurable schedule, so even an XS handles hundreds of metrics comfortably. A dedicated warehouse keeps costs isolated on your bill.
- KPI Tree queries your warehouse and processes aggregated results in its own engine. Raw row-level data is not persisted outside your environment. All Snowflake governance - network policies, RBAC, row-level security, data masking - remains fully enforced.
Related guides
Deep dives into the frameworks and metrics that work with Snowflake.
Connect Snowflake in under an hour.
A guided wizard generates the SQL. Cortex Analyst, Semantic Views, RSA key-pair auth, network policies - ready to go.
