Viewing Data

Data Explorer provides a spreadsheet-like interface for browsing data in your tables, views, and file sources.

Data View Interface

The Data tab displays rows in a paginated grid.

Key features

1. Grid Display — Data presented in a tabular format with sortable columns
2. Column Headers — Show column names; resize and reorder by dragging
3. Pagination — Navigate through large datasets with configurable page size
4. Data Type Formatting — Values formatted based on their type (dates, numbers, etc.)
5. Cell Text Selection — Select and copy cell content directly
6. Inline Editing — Available for editable sources (see Editing Data)

Data is loaded one page at a time via server-side pagination, so performance stays predictable regardless of table size.

Data Navigation

• Page size selector — Choose how many rows to display per page
• Page controls — Move forward, backward, or jump to a specific page
• Record count — Total number of rows is shown in the pagination footer

Row counts

• Tables display an approximate count from database statistics, which is fast but may not reflect very recent changes.
• Views display the count after query execution.
• Click Calculate exact count in the pagination footer to get a precise count. This runs a COUNT(*) query, which may take time on very large tables.

Sorting

There are two ways to sort data:

Column headers — click a column header to sort by that column. Click again to toggle between ascending, descending, and no sort. Hold Shift and click additional headers to add secondary sort levels; each sorted column shows a numbered indicator and a direction arrow.

Data Filter Panel — open the panel (see below) and use the Sort tab to add ORDER BY clauses with explicit ASC/DESC toggles.

Both methods produce the same result. For tables with over 1 million rows, sorting performance depends on indexes — consider adding an index on the source database if sorting is slow on a large unindexed column.

Data Filter Panel

Click the Filter button in the toolbar to open the Data Filter panel. It has three sections accessible via tabs at the top: Columns, Filter, and Sort.

Columns

Select which columns to display. Each column is shown as a toggle — click to show or hide. Use the All / None shortcuts to quickly select or deselect all columns. The tab badge shows the count of visible columns.

Filter

Add WHERE conditions to narrow the displayed rows. Each filter row has three parts:

1. Column — pick from a dropdown of available columns
2. Operator — choose a comparison operator
3. Value — enter the filter value

Available operators:

Click + Filter to add multiple conditions.

Sort

Add ORDER BY clauses. Select a column and toggle between ASC and DESC. Multiple sort levels can be added.

Limit

An optional Limit field at the top restricts the total number of rows returned (e.g., 1000 rows).

Applying changes

Click Apply to apply all settings from the panel — column visibility, filters, sort order, and limit — to the current table view. The panel closes after applying.

Selecting and Copying

Click a row to select it. Hold Ctrl (or Cmd) to select multiple rows, or Shift to select a range. The toolbar shows the number of selected rows.

Copy formats

Select rows and use the right-click context menu or Ctrl+C to copy:

Context menu

Right-click a row to access:

Edit, Add, and Delete actions are only available on editable sources — see Editing Data for the full workflow.

On macOS, use ⌘ instead of Ctrl.

Export

Click the Export dropdown in the toolbar to export data:

• CSV — comma-separated values
• JSON — JSON array
• Excel — .xlsx spreadsheet

Create stream from this view

The Export menu also includes Create stream from this view — a quick way to export the current table to a file target using a stream.

The dialog shows:

• Source — current connection, database, and table with column list
• Target — format (CSV, JSON, etc.), compression, and target path (defaults to the server export folder)
• Stream — auto-generated stream name and a Run immediately checkbox

Click Create to set up and optionally start the export stream. The stream appears in the Streams section where you can monitor progress.

Column Context Menu

Right-click any column header to access:

• Pin Left / Pin Right — freeze the column to the left or right edge so it stays visible while scrolling
• Unpin — release a pinned column back to its default position
• Autosize This Column — resize the column to fit its content
• Autosize All Columns — resize all columns to fit their content
• Reset Columns — restore all columns to their default width and position

Summary tab

The Summary tab provides a statistical profile of the table data.

Overview cards

Three cards at the top show:

• Rows — total row count
• Cols — number of columns
• Time — query execution time

Sample size

Use the Sample dropdown to choose what percentage of data to analyze (default 100%). Smaller samples run faster on large tables.

Column statistics

Each column shows:

Columns may be tagged with badges:

• Unique — all values are distinct
• Low Cardinality — few distinct values relative to row count
• Constant — every row has the same value

Numeric column distribution

For numeric columns, a distribution card shows:

• Min, Q25, Median, Q75, Max
• Standard deviation (Std)

Export

Download the summary in Markdown, JSON, or CSV format using the export buttons.

Related docs

• Editing Data — Insert, update, delete with staged changes
• Examining Table Structure — Columns, keys, indexes, DDL
• SQL Console — Direct and file-aware SQL