Security

Enterprise-grade security and compliance. By design.

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.

We do not store your data. It stays in your warehouse.

KPI Tree reads your warehouse with scoped, read-only credentials and calculates in memory. Its in-memory cache is yours to switch on, per connection, and anything cached is encrypted with your workspace's own keys, or with your own.

Nothing stored. Read-only by design.

KPI Tree connects with scoped, read-only credentials and runs one scheduled query per metric. TLS is verified on every connection.
Snowflake

Snowflake

analytics-prod

Read-only

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. Federated identity.

BigQuery, Databricks and Snowflake sign in as your workspace's own Google service account, so no key or secret is stored.

Keyless sign-in

Signs in as your workspace's own identity

No secret stored
BigQuery

BigQuery

Workspace service account

Databricks

Databricks

Workload identity federation

Snowflake

Snowflake

Workload identity federation

No key to store, rotate or leak.

An in-memory cache. Optional, per connection.

Switch Query Result Caching on for a connection and its query results are held in memory, for as long as you set, for your workspace alone. Switch it off and no query results are kept.

Raw query

Scans your warehouse

Query Result Caching

Cache TTL 1 hour

Pre-aggregated

1 Aug£15,343
2 Aug£15,345
3 Aug£10,536

Served from memory

Warehouse compute spend

Caching enabled
JanFebMarAprMayJun

Switch it off and no query results are kept.

Always Encrypted. A key ring per workspace.

What you cache, whether held in memory or kept briefly as a file of calculated results, is encrypted with keys created for your workspace alone and rotated every 90 days.

Workspace key ring

Created for your workspace alone

Rotated every 90 days

Connection credentials

Encrypted before they are kept

Encrypted

Cached data

Query results and calculations

Encrypted

No other workspace's keys can open it.

Bring Your Own Key (BYOK)Enterprise+

Or encrypt what you cache, and your connection credentials, with keys in your own Google Cloud project, HSM-backed if you choose. Revoke them and KPI Tree can no longer read that data.
Google Cloud

Your Cloud KMS key

In your own Google Cloud project

HSM-backed

Connection credentials

Encrypted with your key

Your key

Cached data

Encrypted with your key

Your key

Revoke the key and KPI Tree can no longer read either.

Bring Your Own Storage (BYOS). Your cache, in your own bucket.

Enterprise+
Or keep all caches in your own Cloud Storage bucket. KPI Tree checks it can use the bucket before it moves, and if access is lost, caching stops rather than falling back to KPI Tree's storage.
Google Cloud

Your Cloud Storage bucket

gs://acme-kpitree-cache, in your own project

In use

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 and compliance without compromise.

Built for organisations where security reviews are thorough and compliance is mandatory.

Security questionnaire

The questions every review asks

0 of 5 answered

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. The gold standard for compliance.

Unlike a point-in-time audit, Type II verifies our controls operate effectively over an extended period, independently examined for Security, Availability and Confidentiality.
AICPA SOC 2 badge

SOC 2 Type II

Examined for

Security

Availability

Confidentiality

SSO. One click, your identity provider.

Secure access through your identity provider. SAML 2.0 and OpenID Connect supported. Your team signs in with credentials they already have.
KPI Tree

Sign in to KPI Tree

With the login you already have

OktaContinue with Okta
or your provider
Microsoft Entra IDGooglePing IdentityOneLoginJumpCloud

SAML 2.0 and OpenID Connect

Directory sync. Users managed automatically.

Sync users directly from your corporate directory (Microsoft Entra ID, Okta, Google Workspace). Access is provisioned and deprovisioned automatically as your team changes.
Okta

Directory sync

Okta, synced two minutes ago

Active

Emma Thompson

Joined Finance today

Provisioned

Sarah Chen

Moved from Finance to Data Team

Group changed

David Mitchell

Left the company

Deprovisioned

Joiners get access and leavers lose it, without anyone being asked.

Audit logs. Who did what, and what was refused.Enterprise

Sign-ins, access and policy changes, data queries and the actions of AI agents and workflows are recorded with who acted and where from, refusals included. Streaming to your own tools is Enterprise+.

Audit log

Who did what, and from where

Kept for 7 days

Assistant access refused

Refused

David Mitchell, from Claude

09:21

Security policy changed

Sarah Chen, AI assistant access

09:14

Signed in

Emma Thompson, Okta, London

08:47
Streams to
Amazon S3DatadogSplunkGoogle Cloud StorageMicrosoft SentinelSnowflakeAny HTTPS endpoint
Enterprise+

Endpoint protection. Restrict access to approved IPs.Enterprise+

Restrict login attempts to your approved IP ranges only. If you use a service like Zscaler, access is limited to your secure network, preventing unauthorised access from outside.

Endpoint protection

Sign-in from approved networks only

On
Zscaler

Zscaler

Your Zscaler egress ranges

Allowed

London office

198.51.100.0/24

Allowed

Anywhere else

Any other address, even with the right password

Refused

Works with Zscaler, Cloudflare and Netskope.

Bring Your Own Key (BYOK) - AI. Your provider, your terms.

Enterprise+
Run KPI Tree's AI on your own OpenAI, Anthropic or Gemini account, under your own agreement with the provider, such as zero data retention.
OpenAI

Your AI provider

Your own OpenAI account, under your own agreement

Your key
OpenAIAnthropicGemini

Advanced

GPT-6.1 Sol

Standard

GPT-6.1 Terra

Light

GPT-6 Luna

Agents, briefings and summaries all run here, billed to your account.

Your admins set the rules. Your team, AI and workflows follow them.

An admin sets each policy once for the whole workspace. It takes effect the moment it is saved, and access is refused on the server, not hidden in the interface. Every policy change, and the refusals it causes, go into the audit log.

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

An assistant through KPI Tree

Your admins are the policy.

  • Only the directory groups you choose, admins included
  • At most 500 rows per query, through read-only credentials
  • Read-only, unless you let chosen groups make changes
  • Every query and every refusal in the audit log

AI assistants. Off, by group, or read-only.Enterprise

Switch off connections from Claude, ChatGPT and other AI assistants for the whole workspace, or limit them to chosen directory groups, admins included. Make assistants read-only, or let only chosen groups make changes.
ClaudeChatGPTGeminiMicrosoft Copilot

AI Assistant Access

Claude, ChatGPT, Gemini and Copilot

Restricted

AI assistant connections

Who can connect an assistant

Allowed groups

Admins included

FinanceData Team

Changes by AI assistants

Read-only when off

Anyone outside those groups is refused, admins included.

Warehouse data. Who sees rows, and how many.Enterprise

Decide whether AI can run SQL on your warehouse, for which groups and up to how many rows. Do the same for warehouse rows in the app, switch off table downloads, and list which outside MCP servers may be connected.

AI Warehouse Queries

SQL from assistants and agents

Restricted

AI may run SQL

Metrics and charts are not affected

Allowed groups

Admins included

FinanceData Team

Rows per query

At most

500

Data downloads

Tables and exports

Outside MCP servers only from your list.

Sign-in. Only the groups you choose.Enterprise

Limit who can sign in to members of chosen directory groups. Groups come from directory sync with Microsoft Entra ID, Okta or Google Workspace.

Sign-In Access

Members of chosen directory groups

Restricted

Allowed groups

From Okta

FinanceLeadership

Emma Thompson

Finance

Signed in

Sarah Chen

Leadership

Signed in

David Mitchell

Sales

Refused

Groups come from your directory, so leavers are out the day they leave.

Workflows. What a workflow may send out.Enterprise

Switch off the steps that send Slack messages, emails and HTTP requests, or HTTP requests alone. List the hosts HTTP requests may call, and stop inbound webhooks starting workflows.

Workflow Controls

What a workflow may send outside KPI Tree

Restricted

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.

Something your security team needs? Bring your questionnaire.

We work with procurement and security reviews directly.