Delete
DescriptionThe Delete transform deletes rows of data from a database. This transform is similar to the update family of transforms in that it takes one or more key fields to determine the rows to delete. |
Supported Engines
|
Options
| Option | Description |
|---|---|
Transform name |
Name of the transform. This name has to be unique in a single pipeline. |
Connection |
The database connection to which data is written |
Target schema |
The name of the Schema for the table to which data is written. This is important for data sources that allow for table names with periods in them. |
Target table |
Name of the table in which you want to do the insert or update. |
Commit size |
The number of rows to change (insert / update) before running a commit. |
The keys(s) to look up the value(s) |
Specify fields to delete the corresponding rows for |