Skip to main content
The filter transformation removes rows that do not match a condition. Only rows that pass the filter are written to the destination.

​
When to Use

  • Sync only completed orders (status equals completed).
  • Exclude test data (environment not test).
  • Sync only recent records (created_at after 2024-01-01).
  • Exclude soft-deleted rows (deleted_at IS NULL).

​
Example

Keep only rows where status = 'completed': 
condition: status = 'completed'
Rows with status pending, cancelled, etc. are excluded.

​
Configuration

Specify a condition expression. The syntax depends on the pipeline engine. Common operators include equals, not equals, greater than, less than, IN, LIKE, IS NULL, and IS NOT NULL.