AI drafts the tedious part. You keep the decision.
Most of technical modeling isn’t design. It’s the same four chores, repeated across every table you import. You work out which columns join and decide which column is the key. Then you write the description nobody budgeted time for and hand-assemble the view the business asked for last week.
Those chores are exactly what AI skills in DeltaVault take off your desk. Every proposal a skill makes arrives as a draft, so you read it before it touches your catalog. The AI drafts the tedious part, and you keep the decision.
Why does the tedious work still land on you?
The joins are the worst of it. Plenty of source systems never declared a foreign key, and the lakehouse doesn’t require one. On Databricks, primary key and foreign key constraints are informational only and not enforced. So a schema that arrives through a file drop or a constraint-free database lands with no recorded joins at all.
Someone then rebuilds them by guessing at parents one pair at a time. And the descriptions never get written, because the sprint ends first.
The usual fix is a chat panel, and it answers well enough. Then what happens? You copy the answer back into the catalog by hand, with no record of what the model saw and no review of what you typed. That moves the typing around rather than removing it.
How DeltaVault drafts keys, joins, views and descriptions
Every AI capability in DeltaVault is a skill, and three skills plus the canvas chat cover the chores above.
Foreign key discovery is the relationships pass of Discover keys and relationships. Run it across every table on a canvas, or narrow it to a subset first. Each candidate comes back as a dashed edge on the canvas, with a confidence score and a short written reason.
Business key discovery runs from the same launch. The key passes propose a primary key for each table in scope, plus a business key where one belongs, on a staging, Data Vault, or data mart table. Scan a source table and its business-key proposal redirects to the staging table that source feeds. Accepting a key replaces the table’s current key, so it goes through review first, because data integration is a decision about business keys.
Metadata enrichment works on the table you’ve selected. The skill drafts a clearer table description, a description for each column, a business name, and the matching business entity where one is evident. Structure is never touched. Sensitive data classification is its sibling. It makes one proposal per column across your sensitivity, personal data, and regulatory schemes, and stays silent on any column it isn’t confident about.
SQL view generation starts from a sentence. On a project or workspace canvas, describe the view you need. Ask AI asks the clarifying question that matters, then parks the result as a proposal card. Accept it and the view designer opens with the tables, filter, and as-of setting already in place. The view’s SQL rewrites live while you correct the proposal in the designer.
Every proposal is a draft you can read
What makes this augmentation rather than automation? Nothing writes on its own. Any skill that writes runs in preview-then-apply mode. Its proposed changes are staged as a plan, and you edit, approve, or reject each item before anything lands.
Only what you approve is applied. Applied changes then go through the same write paths and role checks as a hand edit, land on your active branch, and appear in the same audit log. So “what did the AI change?” has the same answer as “what did anyone change?”
Inspectable means more than an approve button. Every relationship discovery candidate shows its score and its reason, and low-confidence candidates stay in the list so you can make the call yourself. Accept one and each downstream layer gives you its own preview of what it will create there, with staging and persistent staging each behind its own toggle.
Enrichment and classification run with your conventions in context. The naming convention and classification schemes your organization defined are injected into every skill that needs them, and classification proposals are bounded to your own schemes.
None of it is sealed. An organization administrator can fork a built-in skill into an editable version and tune the instructions it runs. That’s the whole case for being AI-native, not AI-added. The same principle carries into integration work. Discovered joins and drafted views are how the bridge to a source that doesn’t hold your model’s shape gets built, not painted, with column-level lineage on every projected column.
Each one is a named skill, and the Ask AI drawer suggests the ones that fit the page you’re on.
This is AI-assisted data modeling with the decision left where it belongs. The repetitive work gets cut, and the meaning, the standards, and the approval stay yours. Try it on a schema you imported last month.
- Open the project canvas and launch Discover keys and relationships across the schema.
- Read the reason on every candidate and reject the ones the evidence doesn’t carry.
- Accept the rest onto your branch with the per-layer preview open, then review the commit like any other change.