Skip to content
SCHEMAVORTEX
Platform

The Sandbox

A place for every analyst's own SQL.

Analysts write their own queries anyway. The Sandbox gives each user a personal space for them: on the governed data, reachable from Power BI by name, and kept apart from the curated Mart.

In short

Business logic belongs in the platform, not in a report.

When a calculation lives in one person's Power BI file, nobody else can find it, check it or reuse it. In the Sandbox it is stored in the platform and served to every tool.

A space for each user

Every user gets a schema of their own. Their views open in Power BI, Excel or any SQL client by name.

Always the current data

A Sandbox view runs when it is queried, so it always reads the current data. Nothing is copied.

Masks still apply

Whoever queries a Sandbox view gets only the values they may read.

Every change on record

Each change to a view is saved as a new version, with who made it and when.

How it works

Built on the governed data, kept apart from it.

Sandbox views read the Vault and the Mart. The Mart never reads a Sandbox view, so personal logic cannot slip into the curated layer.

Governed data
Vaultthe history of every source
Martthe curated views

The Mart never reads a Sandbox view

Sandbox
annamargin_checktop_customers
benchurn_watchregion_mixdraft · waits for ben
carlabudget_vs_actual

Power BI · Excel · any SQL client

When a view proves useful to everyone, the team rebuilds it in the Mart, where changes go through a Mart Plan before they are published.

Proposals

Colleagues propose. The owner decides.

A colleague can suggest a change to someone else's Sandbox view as a draft. The live view keeps running, and nothing changes until its owner approves.

Drafts beside the live view

A proposed change is saved next to the live view. Reports keep reading the live one.

Compared before approval

The owner sees the draft next to the live view, then approves or discards it.

AI proposes, a person approves

A coding agent can draft changes to its user's own views. It can never approve one.

See a Sandbox view go from idea to Power BI.

A short live demo: an analyst writes a view, a colleague proposes a change, and the owner approves it.