Delete
Description:
Delete removes rows from a database table based on lookup keys that match values from the incoming data stream. Use this step when your workflow needs to clean up or purge records — for example, removing outdated entries, deleting processed transactions, or synchronizing deletions between systems. It compares specified key fields from each incoming row against the target table and deletes the matching database records.
Configurations:
| Field Name | Description |
|---|---|
| Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection | Name of the database connection on which the target table resides. |
| Target Schema | The name of the Schema for the table to write data to. |
| Target Table | Name of the target table. |
| Commit Size | The number of rows after which to commit. |
| The keys to lookup the values: | |
| Table field | Field in the table to lookup |
| Comparator | Select from the list of comparators |
| Stream field1 | Table field is compared with Stream field1 using comparator |
| Stream field2 | Table field is compared with Stream field2 using comparator |