Select Columns
Pick and reorder columns
What It Does
Select Columns lets you pick which columns to keep and in what order. Unselected columns are hidden from the result.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Select Columns". It's in the Columns group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Columns | Multi-select | Yes | Choose which columns to keep |
SQL Generated
SELECT name, email, revenue FROM dataNotes
- Null values are handled gracefully - operations skip or preserve nulls where appropriate.
- You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
- The SQL preview shows exactly what will execute - inspect it before applying.
Related Operations
- Delete Columns - Remove columns from the table
- Copy Columns - Duplicate columns with custom names
- Combine Columns - Combine columns and text into one