base.filter_rows

Filter rows of a table by a SQL WHERE-style predicate. Accepts CSV or Parquet input and always emits Parquet output.

  • Kind: standard
  • Network: no

Inputs🔗

NameTypeDescription
tablefile (Parquet, CSV accepted)Source table.
expressionstringSQL WHERE-style predicate, e.g. "age > 30 AND state = 'NY'".

Outputs🔗

NameTypeDescription
resultfile (Parquet)Rows of the input table matching the predicate.

Example🔗

- id: 01890000-0000-0000-0000-000000000001
  name: base.filter_rows
  inputs:
    - 01890000-0000-0000-0000-000000000000
  args:
    expression: "age > 18"