Table Delete Rows

Table Delete Rows is a transformation component that deletes rows from a target table. Rather than delete a set of rows based on a static condition, this component deletes rows by matching rows to the key values identified in an input flow. Meaning, the information received from an input component, such as Table Input.

Multiple key column mappings can be entered. These mappings form an AND condition, so all mappings must match for the row to be deleted. This is analogous to a JOIN condition.

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, read Vacuuming Tables.

Properties

Name = string

A human-readable name for the component.

Schema = drop-down

Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information, read Schemas.

Target Table = drop-down

The table to delete rows from.

Key Column Mapping = column editor

Source Column: The source column from the input flow.
Target Column The target column from the selected target table.

Snowflake	Databricks	Amazon Redshift
❌	❌	✅