Exploring table data
Use the preview toolbar to filter, sort, show or hide columns, and switch between data and schema views — all without writing SQL.
The table preview page (Analytics → Tables → [table] → Preview) includes a toolbar that lets you slice and explore data interactively. You can filter rows by value, reorder by a column, hide columns you don't need, and flip between the live data grid and the table's column schema — all in one place.
DATA / STRUCTURE toggle
The segmented DATA / STRUCTURE control at the left of the toolbar switches between two views of the same table:
- DATA — the live data grid, paginated from the warehouse in real time.
- STRUCTURE — the column schema: name, type, primary-key flag, description, and governance classification for every column.
Switching views does not reset any active filters or sort. If you navigate to the legacy /schema URL for a table, you are automatically redirected to the Preview page with STRUCTURE selected.
Filters
Click Filters in the toolbar to open the filter builder. You can add one or more conditions; all conditions are combined with AND (every condition must match).
Supported operators
| Category | Operators |
|---|---|
| Equality | equals · not equals |
| Text | contains · starts with · ends with |
| Comparison | ≥ · ≤ · > · < |
| Range | between |
| Membership | in (a list of values) |
| Null check | is null · is not null |
Building a filter
- Click Filters → + Add condition.
- Pick a column from the dropdown (only columns you can read are shown — masked columns are not filterable).
- Pick an operator.
- Enter a value (or a comma-separated list for in; two values for between).
- Repeat for additional conditions with + Add condition.
- Close the popover — the grid reloads immediately with the filter applied.
The Filters button shows a badge with the number of active conditions.
Clearing filters
Open the Filters popover and remove individual conditions with the × on each row, or use the ⋯ overflow menu → Clear filters to remove all of them at once.
Filters are applied server-side. The warehouse evaluates your conditions; only matching rows are returned. The row count in the toolbar updates to reflect the filtered total.
Filtered pagination still uses keyset cursors — even with an active filter, the grid never loads the full table client-side. Each scroll batch is a fresh server fetch on the filtered result set.
Empty filter results
If your filter conditions match no rows, the grid shows No rows match these filters with a Clear filters link. Click it to remove the filter and return to the full result set.
Sort
Click Sort in the toolbar to pick a sort column and direction. The current release supports sorting by a single column at a time.
- Pick a column from the list.
- Toggle Ascending or Descending.
The Sort button shows a badge when a sort is active. Clicking a column header in the grid also sets the sort (same behavior as the Sort menu).
Columns
Click Columns to show or hide individual columns. A checkbox list of all available columns appears; uncheck any column to remove it from the grid view. The column is hidden only for your current session — it is not deleted or modified in the warehouse.
Column visibility is ephemeral. It resets when you leave the page. Hidden columns remain present in the table; they are simply not rendered in the current view.
Overflow menu (⋯)
The ⋯ menu at the right of the toolbar provides additional actions:
| Action | What it does |
|---|---|
| Download as CSV | Downloads the currently loaded rows as a .csv file |
| Download as JSON | Downloads the currently loaded rows as a .json file |
| Clear filters | Removes all active filter conditions |
Downloads contain only the rows currently loaded in the grid, not the full table. Infinite scroll loads rows in batches of 100 as you scroll — if you want more rows in your download, scroll down to load them first. Full-table export is not currently supported from the preview.
Combining controls
Filters, Sort, and Columns work together. A typical workflow:
- Open Filters → add
status = active. - Open Sort → sort by
created_atdescending. - Open Columns → hide columns you don't need for the current analysis.
- Scroll through the filtered, sorted result set.
- Download loaded rows as CSV if you want to share them.
Related
- Editing table data — add, edit, and delete rows directly in the grid.
- Managed tables — lifecycle, write modes, and table creation.
- Classification & masking — how column masks affect which columns are filterable.
- Querying — reading from workflows, notebooks, and SQL for more complex queries.