You can add filters to refine the data selected for replication or copying by specifying conditions that include or exclude rows from your source tables. Filters help you work with only the relevant subset of data when transferring information to target databases, data warehouses, file systems, or Kafka streams. The process involves selecting a schema and table, defining a filter expression, validating it, and saving the filter.
To change table mapping for set of selected rows:
You can optionally add one or more filters (conditions and clauses) that refine the data with which you want to work. Filters are useful to copy or replicate a subset of data from your database sources to your specified target database, data warehouse, file systems, or Kafka stream.
- Click the Schema drop-down list and select the name of the schema that contains the table you want to filter.
- Click the Table drop-down list and select the name of a table in the selected schema you want to filter.
- In the Filter expression text field, copy and paste or type the Boolean expression whose results, if true, include the row based on a valid expression for the column, and if false, ignore the row. For example, type Country == 'CAN' to include data rows in which the value in the Country column is Canada.
- Click Validate Expression to validate that the
expression you entered is valid for the runtime server. The results
are displayed in the Validation results field. If the
validation failed, the results include information about problems with the
expression or other reasons for the failed validation. Note: You can still add the filter if the validation failed.
- Scroll to see any details too long to fit the window or drag the corner of the window to resize it.
- Click Add to save the filter.