Delete Rows Component
Table Delete Rows Component
Delete rows from a target table.
Rather than delete a set of rows based on a static condition, this component deletes rows based on matching rows to the key values identified in an input flow.
Deleting rows requires a vacuum afterwards to recover space. This component does not arrange that vacuum for you. If you are removing a large portion of the table, it may be better to rewrite the rows you want to keep to a new table and then drop the existing table and rename the new one. For more information on vacuuming tables see here.
|Name||Text||The descriptive name for the component.|
|Schema||Select||Select the table schema. The special value, [Environment Default] will use the schema defined in the environment. For more information on using multiple schemas, see this article.|
|Target Table Name||Select||The table to delete rows from.|
|Key Column Mapping||Input Column Name||The source column from the input flow|
|Target Column Name||The target column from the target table|
Multiple Key Column Mappings can be entered. They form an AND condition, so all keys must match for the row to be deleted. This is analogous to a JOIN condition.
This component deletes from 'target_plane_info' any rows where the value of 'manufacturer' is EMBRAER or BOEING. In this case, those input values come from a Fixed Flow Input component, but they could have come from any component with an output connector.
A name is set, along with the table to delete from, and the column mappings.