Editing in grids
DeltaVault’s grids, on the Catalog and on a project’s or workspace’s Catalog page, are built for editing metadata directly: rename a column, fix a data type, or fill a whole range, without leaving the list. This guide covers how that editing works wherever a grid appears: saving, choosing your columns, working with ranges, and pasting in from a spreadsheet.
Every change saves on its own
Section titled “Every change saves on its own”Leave a cell and DeltaVault writes it. There is no Save button to find and nothing sits unsaved in a draft: every edit, whether you typed it, filled it, or pasted it, lands the moment you move on.
Saved is not the same as published. Your edits land on your current branch, the same as any other catalog change, and commit review stays the checkpoint before anything reaches main.
When a change cannot be saved, because it fails validation or you do not hold the editor role, the cell goes back to its stored value and a message tells you which field failed and why.
This is the same editing model behind the connections, business entities, glossary, and business models lists elsewhere in DeltaVault: each cell saves as you go, and each list’s name is the link, so a single click opens the item and a double click renames it in place.
Choosing which columns you see
Section titled “Choosing which columns you see”Open the column chooser and you will find every field DeltaVault tracks for what the grid shows, not only the ones visible by default. Toggle on whichever ones you need.
Your choice of columns, their order, their widths, and your sort all follow you to any device you sign in on, because the layout saves to your account rather than to the browser. This saved layout also carries over to DeltaVault’s utility and admin lists (for example, projects, workflows, schedules, macros, teams, and knowledge documents), not only the catalog and modeling grids. When you want the defaults back, Reset grid layout restores them.
Working with ranges
Section titled “Working with ranges”Select a range the way you would in a spreadsheet, drag the fill handle to copy a value across cells, or copy with the usual keyboard shortcuts, all without entering a separate edit mode first: the grid is ready for it at any time.
Fill a range and DeltaVault saves every cell in it together, as one change, rather than one at a time.
Pasting from a spreadsheet
Section titled “Pasting from a spreadsheet”Copy rows out of Excel, Google Sheets, or even a plain text editor, then paste them straight onto the grid. DeltaVault maps the values to the columns you can see, left to right starting from the cell you paste into, so show the fields you want to fill before you paste.
Cells that land on existing rows save the moment the paste completes.
Pasting more rows than the grid has
Section titled “Pasting more rows than the grid has”Paste a block that runs past the last row of the columns grid, or past the last row of a schema’s Tables tab, and DeltaVault asks before it creates anything: the schema’s tables grid creates the pasted tables in that schema. A dialog previews every row the paste would add and flags the ones that are not ready: a missing name, a data type it does not recognize, or a name that is already in use.
Confirm creates every previewed row at once, or none at all if even one of them is flagged. Cancel leaves the new rows uncreated. Either way, the cells that landed on existing rows in the same paste were already saved before the dialog opened, and the dialog states how many.
A connection’s Tables tab, a catalog’s Tables tab, and the tables grid on a project’s Catalog page do not create rows from a paste. Paste past their last row and nothing beyond the existing rows is added.
Data types when you paste
Section titled “Data types when you paste”A data type you paste into a new row resolves against the canonical catalog and its
aliases the same way the type picker does, so pasting int stores it as INTEGER.
Editing the type on a row that already exists is different: it expects the
canonical name itself, since an alias there does not resolve. When DeltaVault does
not recognize a type, it is flagged rather than stored as typed, which is exactly
what the paste-to-create dialog catches before any row is created.
Viewers
Section titled “Viewers”Viewers see the grid read-only: no cell opens for editing, and a paste never creates rows.
For how to search and set a column’s exact data type, see Choose column data types.