Split Column

Split a column by delimiter into multiple

What It Does

Split Column breaks a text column into multiple columns using a delimiter. For example, split "John Smith" by space into first_name and last_name.

Click the + button in the toolbar or press the operation picker, then search for "Split Column". It's in the Columns group.

Field	Type	Required	Description
`Column`	Column select	Yes	The column to split
`Delimiter`	Text	Yes	Character(s) to split on
`Number of parts`	Number	Yes	How many columns to create

SELECT *, split_part(full_name, ' ', 1) AS first_name, split_part(full_name, ' ', 2) AS last_name FROM data

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.