clean_filter
Filter rows in a dataset by SQL condition, either dropping or keeping matches to clean and prepare data for analysis.
Instructions
New source with rows matching where_sql dropped (default) or kept.
`where_sql` is a DuckDB WHERE clause without the WHERE keyword:
e.g. `"age < 0 OR age > 130"` or `"region IS NULL"`. Defaults to
drop-matching (filter-out semantics); pass `keep=True` to keep instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keep | No | ||
| alias | No | ||
| source_id | Yes | ||
| where_sql | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||