An assistant straight on the warehouse
The connection string is the policy.
- Every table and every row the connection can reach
- Anyone who has the connection string, admins or not
- Writes, if the credential allows them
- No record of who asked what
Security
We do not store your data. Our in-memory cache is optional, and anything cached is encrypted with your keys. SOC 2 Type II, SSO, audit logs and security policies for AI.
Snowflake
analytics-prod
Scoped credentials
Reads only the tables your metrics need
TLS verified
Checked before every query
One scheduled query per metric
Revenue, nightly, calculated in memory
Read-only, so your warehouse is never written to.
Keyless sign-in
Signs in as your workspace's own identity
BigQuery
Workspace service account
Databricks
Workload identity federation
Snowflake
Workload identity federation
No key to store, rotate or leak.
Raw query
Scans your warehouse
Cache TTL 1 hour
Pre-aggregated
Served from memory
Warehouse compute spend
Switch it off and no query results are kept.
Workspace key ring
Created for your workspace alone
Connection credentials
Encrypted before they are kept
Cached data
Query results and calculations
No other workspace's keys can open it.
Your Cloud KMS key
In your own Google Cloud project
Connection credentials
Encrypted with your key
Cached data
Encrypted with your key
Revoke the key and KPI Tree can no longer read either.
Your Cloud Storage bucket
gs://acme-kpitree-cache, in your own project
Query results
From every connection
Calculations
Every metric's nightly results
Business models
Scenarios and plans
Driver analysis
Correlation and causation runs
Nothing is kept in KPI Tree's storage. If access is lost, caching stops.
Your data stays in your warehouse. Your cache stays under your keys.
Security questionnaire
The questions every review asks
Is the platform independently audited?
SOC 2 Type II, examined for Security, Availability and Confidentiality.
Can our team sign in with our identity provider?
SAML 2.0 and OpenID Connect, with 27 identity providers.
Are users provisioned and removed automatically?
Directory sync with Microsoft Entra ID, Okta and Google Workspace.
Is there an audit trail we can stream to our SIEM?
Every sign-in, change, query and refusal, streamed to Splunk, Datadog, S3 and more on Enterprise+.
Can access be limited to our network?
Approved IP ranges only, with Zscaler, Cloudflare or Netskope, on Enterprise+.
Bring the rest. We answer security questionnaires directly.

SOC 2 Type II
Examined for
Security
Availability
Confidentiality
Sign in to KPI Tree
With the login you already have
SAML 2.0 and OpenID Connect
Directory sync
Okta, synced two minutes ago
Emma Thompson
Joined Finance today
Sarah Chen
Moved from Finance to Data Team
David Mitchell
Left the company
Joiners get access and leavers lose it, without anyone being asked.
Audit log
Who did what, and from where
Assistant access refused
RefusedDavid Mitchell, from Claude
Security policy changed
Sarah Chen, AI assistant access
Signed in
Emma Thompson, Okta, London
Endpoint protection
Sign-in from approved networks only
Zscaler
Your Zscaler egress ranges
London office
198.51.100.0/24
Anywhere else
Any other address, even with the right password
Works with Zscaler, Cloudflare and Netskope.
Your AI provider
Your own OpenAI account, under your own agreement
Advanced
Standard
Light
Agents, briefings and summaries all run here, billed to your account.
The connection string is the policy.
Your admins are the policy.
AI Assistant Access
Claude, ChatGPT, Gemini and Copilot
AI assistant connections
Who can connect an assistant
Allowed groups
Admins included
Changes by AI assistants
Read-only when off
Anyone outside those groups is refused, admins included.
AI Warehouse Queries
SQL from assistants and agents
AI may run SQL
Metrics and charts are not affected
Allowed groups
Admins included
Rows per query
At most
Data downloads
Tables and exports
Outside MCP servers only from your list.
Sign-In Access
Members of chosen directory groups
Allowed groups
From Okta
Emma Thompson
Finance
Sarah Chen
Leadership
David Mitchell
Sales
Groups come from your directory, so leavers are out the day they leave.
Workflow Controls
What a workflow may send outside KPI Tree
External actions
Slack messages, emails and HTTP requests
Outbound HTTP requests
Listed hosts only, api.acme.com
Inbound webhooks
A workflow started from outside
Notifications to your own team and KPI Tree's briefings are not affected.
We work with procurement and security reviews directly.