Table Delete Rows
The Table Delete Rows transformation component lets you delete rows from a target table. The component matches the rows to key values in an input flow—that is to say, the information received from an input component, such as Table Input—and deletes any rows that meet all the "match" conditions.
Multiple key column mappings can be entered. These mappings form an AND condition, so all mappings must match for the row to be deleted.
Deleting rows requires the use of a Vacuum component afterward to recover space. The Table Delete Rows 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, then drop the existing table and rename the new one. For more information on vacuuming tables, read Vacuuming Tables.
Use case
This component can be used to perform targeted deletions of rows within your data. For example, you can use it to:
- Remove discontinued products from a sales catalog by matching product codes to discontinued products.
- Remove invalid transactions from financial data by matching invalid transaction IDs or values.
- Delete personal data to comply with data protection rules by matching a customer's personally identifiable information.
Properties
Name = string
A human-readable name for the component.
Schema = drop-down
Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, 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.