Loading the documentation…
The Preview tab of a table popup shows a table's rows so you can check the data without writing a query. You can search, filter, sort, page through and download the rows. For deploying, running and deleting tables, see Deploy, run, truncate and monitor tables.
The grid is a dense, read-only view. It loads one page at a time from the platform: paging, filtering and sorting run on the server, so a large table is never loaded whole.
On a Dictionary, a Dimension or Fact table, or a Static table, the tab loads nothing on its own. Before the first load it reads Load the dictionary preview to get started, Load the table preview to get started or Load the static table preview to get started, with a Refresh button; click it to load the rows. A view has a Preview tab in its own popup too; see Views.
If the query fails, an error banner reads Query failed, with the reason and a Retry button. Click Retry to run the query again. A failed query does not clear the tab: the last good result stays on screen, so you can keep reading the rows you had, or correct your search.
Opening a table and reading its preview needs View Warehouse Objects; see Warehouse permissions and row-level security.
Preview needs two things: the table must be saved, and it must be deployed. The messages name the table kind.
| Table | Not saved yet | Saved but not deployed |
|---|---|---|
| Dictionary | Dictionary Not Created, then Please save the dictionary first to preview data | Hover the disabled tab to read Dictionary must be deployed to preview data |
| Dimension or Fact | Table Not Created, then Please save the table first to preview data | Hover the disabled tab to read Table must be deployed to preview data |
| Static | Static Table Not Created, then Please save the static table first to preview data | Hover the disabled tab to read Table must be deployed to preview data |
If the table is not saved yet, save it first. If it is saved but not deployed, deploy it from its Settings tab: Dictionary settings, Dimension and fact settings or Static table settings. Dimension, Fact and Static tables can also be deployed from the tree by right-clicking them and choosing Deploy; see Deploy, run, truncate and monitor tables.
The control itself works the same way as on other grids; value lists, condition filters, clearing filters and the sort cycle are described in Filter, sort and search.
The export control works like it does on other grids: pick the format, then click the download button. See Export and copy for the control itself.
table_123.a, b, c.A Lake table's Preview tab has two sides. Lake shows the table's own rows, and Source shows the rows as they come from the source system. Switch between them from the toolbar.
_Source to the file name, so it stays distinct from the Lake download.For the table setup around the preview, see Configure a table.
Every text column, ignoring case, and the match can appear anywhere inside a value. The search runs against the whole table, so it is not limited to the page you are on.
The preview returns to the first page whenever the search, a filter or the sort changes, so you always see the start of the new query.
Open the column's filter menu and choose the empty entry. A blank selection filters for the empty value.
Filter menus cascade. Each menu offers the values that exist under the other columns' active filters and your search, so filtering one column narrows the others. Changing a filter reloads the lists.
Yes. A preview download is built from the same search, filters and sort as the grid, so your choices carry into the file.
In an Excel download, a column that holds a list is rewritten from its raw form to plain text, in the form a, b, c. The other formats are not rewritten.
Page sizes stop at 500 rows, and a preview request is capped at 1,000 rows.
Downloads follow the popup's name, and a download from the Source side adds _Source. When the popup has no name of its own, the file falls back to the table's id, such as table_123.
The Source side loads only when DataMind can resolve the table's source: its datasource, database and schema. When it cannot, nothing is fetched and the grid stays empty.
The tab loads nothing until you ask it to. Click Refresh, and the rows appear. Before that first load, the tab reads Load the dictionary preview to get started, Load the table preview to get started or Load the static table preview to get started.
The table has not been saved. The tab reads Dictionary Not Created, Table Not Created or Static Table Not Created until the table exists. Save its General step first, then deploy the table.
That is intended. The tab keeps the last good result on screen instead of clearing it, so you do not lose the rows you were reading. Read the reason under Query failed, fix the problem, then click Retry.