The filter clause determines how rows are filtered in the target table based on criteria for a column in the table.
To design a filter clause, you can specify the column names in the target table and any transformation language functions that use the column names as arguments. To set multiple criteria, use the operators AND and OR. The filter clause must evaluate to TRUE or FALSE.
For example, you might ingest the following source table:
To filter the rows that you ingest to the target, you might use the following filter clause to filter the rows by area code