Delete

Delete

Description

The 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.

Hop Engine	✓
Spark	?
Flink	?
Dataflow	?

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.