Data Modelling (Beta)
Data Modelling lets you explore a source’s tables and columns, then build curated “models” on top of them — saved, named definitions of which tables matter, how they relate to each other, and what each column means.Schema Explorer
The default view of a source’s structure is the Schema Explorer: a list of tables on the left and a column detail pane on the right. It shows row counts and column counts per table and lets you browse columns and sample data. This is read-only inspection.Exploring and navigating models
| Control / Button | What it does |
|---|---|
| Table list (Schema Explorer) | Browse every table on the source; click a table to see its columns, row count, and column count |
| Open Data Modelling UI | Switches from the Schema Explorer into the model builder |
| Back to Schema Explorer | Returns from the model builder to the plain browser |
| Model grid | Shows every model already built as cards, each with name, description, a materialization label, and when it was last updated |
| New model | Opens a dialog to create a model (name, optional description, and materialization choice) |
| Model card (click) | Opens that model in the editor |
| Card menu → Edit | Opens the model in the editor |
| Card menu → Delete | Moves the model to Trash |
Inside the model editor
| Control / Button | What it does |
|---|---|
| Entities list (left) | The physical tables on this source; add one to the model with a click |
| Suggestions list (left) | AI-proposed relationships between tables, each with a confidence score, plus accept (✓) and dismiss (✗) buttons |
| Canvas | The working area where tables appear as boxes and relationships as lines between them |
| Zoom in / Zoom out / Fit view | Navigate the canvas |
| Properties panel (right) | Edit the selected model’s details, relationships, the columns each table contributes, and preview the generated query |
| Materialize | Persists the model so it can be queried directly; available only for non-ephemeral models |
| Save Model | Saves your current changes |
| Models (back button) | Returns to the model list; prompts you to confirm if you have unsaved changes |
Schema Drift
A data source’s structure can change underneath you. The Schema Drift area watches for these changes, records them as alerts, and lets reviewers triage and resolve them. Each alert carries a severity (Info, Warning, or Critical), when it was first detected, how many times it has been seen, and a structured before/after view.| Control / Button | What it does |
|---|---|
| Open alerts tab | The active triage list — drift changes still needing attention |
| History tab | All alerts regardless of status, for review and audit |
| Snapshots tab | The timeline of captured structure snapshots |
| Policy tab | Configure who is notified about drift and when |
| Alert row (click) | Opens the structured detail: tables and columns added, removed, or changed |
| View | Opens the same alert detail |
| Acknowledge | Marks an open alert as seen, with an optional note; recorded in the audit trail |
| Resolve | Closes out an alert once handled; logged in the audit trail |
| View snapshot diff | Compares previous and new captured structures side by side |
| Status indicators | Each alert shows Open, Acknowledged, Resolved, or Auto-resolved |
Drift alert policy
| Control / Field | What it does |
|---|---|
| Recipients | Choose which roles receive the alert email — data source owner, original creator, department admins, org admins |
| Custom emails | Add extra recipients beyond the role list |
| Severity threshold | Set the minimum severity that triggers a notification |
| Quiet hours | Defer notifications during a chosen time window and time zone |
| Save / Reset | Save your policy changes, or discard them |
Who can use it
- Owners and editors of a data source build and curate its models and triage drift.
- Viewers can browse the Schema Explorer, open models, and review drift alerts, but cannot change models or resolve alerts.
- Department admins and org admins are the natural default recipients for drift alerts.