Querying

The data grid

Edit items in place, review pending changes, and commit them in one pass.

Every result in a query tab lands in the same grid, and every cell edits in place. Nothing is written to DynamoDB until you commit. Edits, added rows and deleted rows accumulate as pending changes that you review and apply in one pass.

A cell editor open over the results grid

See it in action

Edit a cell

Double-click a cell, or focus it and press Enter. A single click only focuses the cell, so you cannot change a value by brushing past it. Press Enter to stage the edit, and Escape or a click outside to discard it. Committing the value the cell already held stages nothing.

Dynomatic routes the editor by the attribute’s DynamoDB type.

Type In the grid Editor
S string The text Text box anchored to the cell. Shift+Enter adds a newline, Enter saves
N number The digits Number input. A value past DynamoDB’s 38 significant digits shows Invalid DynamoDB number and refuses to save
BOOL A TRUE/FALSE segmented pill Click a segment, or press Space or Enter on the cell. The change stages immediately, with no popover
B binary The encoded value Text box with a Binary encoding toggle between b64 and 0x. A bad value shows Invalid base64
NULL null Not editable in the cell. Alt-click the row to change the type in the JSON sheet
M map A JSON preview JSON editor in the popover, with parse errors blocking the save
L list A JSON preview Tag editor when every element is a string, a number or binary. JSON editor for anything mixed
SS string set The members Tag editor, which does not allow duplicates
NS number set The members Number tag editor, which does not allow duplicates
BS binary set The members Binary tag editor with the same b64 and 0x toggle
Vector attribute vector · N dims Read-only. Hovering shows the first values, and no editor opens

A vector attribute is one named by a vector index on the table, never one guessed from the shape of its value.

Edit a whole item

Alt-click a row, or right-click it and choose Edit Row, to open the Edit JSON sheet. It holds the full item, a Marshalled toggle between DynamoDB JSON and plain JSON, schema validation and template variable chips. On a table with vector attributes the vector opens folded behind a N dims placeholder, and a save that changes it is refused. Adding a row is the one place a vector can be authored.

Add and delete rows

Add row opens the same JSON sheet, seeded with the table’s key attributes. Saving queues an added row.

To delete, tick the row checkboxes and press Delete N rows. There is no confirmation dialog, because the deletion is queued rather than performed. Shift-click a second checkbox to select a range.

Review and commit

The action bar shows a diff chip reading N pending changes with one colored square per kind. Clicking a square opens the review sheet filtered to that kind.

The Pending Changes sheet with several staged edits

The Pending Changes sheet has All, Add, Update and Delete tabs with counts, field-level diffs for each row, Revert All, and Apply All to write everything in one pass. A toast reports how many rows were committed.

Reverting needs no confirmation. Use Revert in the chip’s popover, or the pinned status cell at the start of a changed row.

Warning: On a table classified as production the commit button turns red and reads Commit to prod, and a warning banner names the workspace you are about to write to.

Selection and bulk actions

Selecting rows slides the action bar from its default row (Export, Import, Columns, Add row) to a selection row carrying the selected count, Delete N rows, Copy to Table and an export scoped to the selection. Bulk actions require the Pro plan.

Right-click a cell

The context menu offers Filter by… (append the value as a filter, replace the current filter, or filter on an index key), Select Row, Edit Row and Delete Row. A row with staged edits adds Revert Row Changes, and a row already marked for deletion offers Undo Delete instead. On a table with a vector index, a row carrying that index’s vector also gets Find similar.

Columns and per-table settings

Columns searches, shows, hides and reorders columns, and the layout is remembered per table.

Override table settings opens the per-table popover holding page size, stream batch size, Auto-Scan on Open and Lock Key Editing. Each row states which tier it inherits from and offers a reset. With the key lock on, partition, sort and index key attributes on existing rows render as Key attribute pk, editing is locked and open no editor. New rows are exempt. The same rows appear under Fetching & Editing in the tab’s Table settings dialog.

Last updated on