Full immutable history
Each version of each row is kept — nothing is ever overwritten or thrown away.
The Vault
The Vault keeps every version of every row, so a source can change shape without taking your reports down with it.
The mechanism
Source systems inevitably change, which typically breaks downstream reports. The Vault is designed to absorb these changes automatically.
Each version of each row is kept — nothing is ever overwritten or thrown away.
When a source adds a column or changes a type, the columns your reports already read stay exactly as they were.
Add computed columns right in the Vault to derive business-ready values, with the source data untouched.
Restore the lake to any earlier moment, and the history stays intact.
How it works
When a source changes a column's type or adds a new one, SchemaVortex stores it as a new, versioned column. The original lives on unchanged; it just stops loading.
'Address' column's type changed · 'ZipCode' column addedCustomerIdv1Namev1Addressv1 · keptAddress_v2v2 · addedZipCodev2 · addedOne table, every version: columns are only added, never altered or removed.
One table exposes every column across every version. Existing columns are never altered or removed, so the columns a report reads don't change underneath it; rows from before a new column existed show it as empty. Most systems let a column change type in place, quietly breaking the dashboards downstream — the Vault rules that out.
Current state: what everyday reporting reads.
The full record, for audits and for looking back in time.
A short live demo: we change a source's schema in front of you, and the report keeps reading the same columns.