Delete Columns
Remove columns from the table
What It Does
Delete Columns removes selected columns from the result. The opposite of Select Columns.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Delete Columns". It's in the Columns group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Columns | Multi-select | Yes | Choose which columns to remove |
SQL Generated
SELECT * EXCLUDE (temp_col, notes) 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
- Select Columns - Pick and reorder columns
- Copy Columns - Duplicate columns with custom names
- Combine Columns - Combine columns and text into one