Automation Designer

Import from Integration

Pull data from a connected integration

Import from File

CSV, Excel, Parquet, JSON upload

Import from API

REST / GraphQL endpoint ingestion

Import from Data Locker

Read from managed data locker store

New Table

Create an empty table with defined schema

Import Sample Data

Load built-in sample datasets

Clean

Trim, fix nulls, normalise whitespace

Find Replace

Pattern-based find & replace on columns

Text to Columns

Split delimited text into columns

Validate

Assert types and constraints

Flatten JSON

Expand nested JSON into flat columns

Sample

Random or top-N row sampling

Standardize

Normalise formats (dates, phone, codes)

Edit Columns

Rename, cast, compute derived columns

Select Columns

Keep or drop columns

Filter

Row-level filter expression

Deduplicate

Remove duplicate rows

Sort

Sort by one or more columns

Pivot

Wide-format pivot

Unpivot

Melt wide to long format