Data modes: grid, preview pin and static pin

Data modes: grid, preview pin and static pinThe three kinds of data a cell can hold, and why a command can behave differently on each. Many "why did this do nothing?" questions come down to which kind of data is selected. A cell holds one of three kinds: grid data (typed, pasted or imported — no restrictions), a preview pin (a live, read-only page of a query result) or a static pin (the full query result, loaded once and still refreshable from its SQL). Throughout this documentation a "Behaviour by data mode" table states what a command does on each.

Where to find it

Get Data → Data Sources → Preview / Static

What this page covers

Grid data, preview pins and static pins
What a saved project keeps for pinned data
What a saved project stores for pinned data
Filtering large pinned tables
Choosing the pin mode

Settings and controls documented

Grid data (typed, pasted or imported cells)
Preview pin (live, paged query result)
Static pin (full query result loaded)

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.