Table Delete Rows
    • Dark
      Light

    Table Delete Rows

    • Dark
      Light

    Article Summary

    This article is specific to the following platforms - Redshift.

    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.

    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.

    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.


    Properties

    PropertySettingDescription
    NameTextA human-readable name for the component.
    SchemaSelectSelect 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 NameSelectThe table to delete rows from.
    Key Column MappingInput Column NameThe source column from the input flow
    Target Column NameThe target column from the target table

    What's Next