Add Rows

Manually add new rows to the table

What It Does

Add Rows lets you manually insert new rows into your table. Enter values for each column to create new records directly in the browser.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Add Rows". It's in the Data group.

Configuration

FieldTypeRequiredDescription
RowsRow editorYesValues for each column in the new row(s)
SQL generated under the hood 
SELECT * FROM data
UNION ALL
SELECT 'value1', 'value2', 100 -- your new row
Try this operation →

Related Operations

  • Join - Join with another file/table
  • Unnest - Explode delimited column into rows
  • Fill Missing - Fill null values