Data tables

Our Data table isn’t a separate block type, but a part of SQL and Code blocks used to display dataframe contents.

The data table interface provides powerful tools to explore, analyze, and present your data. Through intuitive controls for sorting, filtering, cell formatting, and column customization, you can make your data easier to understand and highlight important bits.

Sorting

To sort dataframe rows by particular column, click on its name, and from the column menu, select if you want to sort ascending or descending.

Filtering

To filter your dataframe, click on Filter in the column menu and fill in required data. Alternatively, you can use the Filter button from block actions.

If dataframe has at least one filter applied to it, you’ll see a list of applied filters on top of the data table. From there, you can edit, remove, and add new filters.

Cell formatting

To make data easier to digest, you can highlight important bits with a pop of color. To open cell formatting configuration, click the Format button at the bottom of the data table.

Here you can select if you want to apply single color formatting to cells that match a certain condition or if you want to apply color scale to all cells in a column.

Renaming column

To change column name, click Rename in the column menu and enter a new name. Pressing Enter will rename the column, and pressing Esc will cancel renaming.

For columns with a custom name, there will be a Reset name button in the column menu that restores the original column name.

Hiding column

In the same menu, you can click Hide column to hide it from the data table. To see a list of hidden columns, click on the eye icon in the top left corner of the data table. Clicking on a column in this list will make it visible again.

Reordering columns

Columns can be rearranged just by dragging them around.

Text wrap

By default, cells in the data table render data only in single line, so longer texts get trimmed. With Wrap cells enabled (you can find it in the column menu), text will be wrapped instead (up to 10 lines per cell).

Copying cell content

You can always select a portion of text in a cell and press Cmd + C or Ctrl + C to copy it. To copy the whole content of the cell, you need to select it first by triple-clicking on it. Now, if you press Cmd + C or Ctrl + C (or use the context menu to copy), the whole content of the cell will be copied instead.