Complete reference for every recipe stage — Filter, Join, Aggregate, Pivot, Impute, Sort, Sample, and Custom SQL
| Stage | Description | Input | Output |
|---|---|---|---|
| Filter | Select rows matching conditions. Supports AND/OR logic, comparison operators, and NULL checks. | Any dataset | Filtered dataset |
| Join | Combine two datasets on matching columns. INNER, LEFT, RIGHT joins supported. | Two datasets | Joined dataset |
| Aggregate | Group by columns and compute summary statistics: COUNT, SUM, AVG, MIN, MAX, and custom expressions. | Any dataset | Aggregated dataset |
| Pivot | Reshape data — convert rows to columns. Specify index, columns, and values. | Any dataset | Pivoted dataset |
| Impute | Fill missing values using mean, median, mode, constant, forward-fill, or backward-fill strategies. | Any dataset | Dataset with filled nulls |
| Sort | Order rows by one or more columns, ascending or descending. | Any dataset | Sorted dataset |
| Sample | Select a random subset — by count or percentage. Supports seed for reproducibility. | Any dataset | Sampled dataset |
| Custom SQL | Write arbitrary SQL against the current dataset. Full power of the target backend. | Any dataset | SQL result dataset |