Delete

Delete removes rows through a Connection resource.

Unlike Query and Upsert, it has no Batch Size — the statement runs as written.

The activity has four tabs: Configuration, Query, Input, and Output.

Configuration

Field	Required	Description
Name	Optional	Name of the component.
Description	Optional	Description of the component.
Connection	Optional	The database connection resource to run through.
Schema	Optional	Schema to delete within.
Tables	Optional	Tables to delete from.

Query

Field	Required	Description
SQL Query	Optional	The SQL statement to run.

The statement must be written in the dialect of the engine set as Type on the Connection resource.

warning

A DELETE without a WHERE clause removes every row in the table. Scope the statement, and test against a non-production database first.

Input

Field	Required	Description
Inputs	Optional	Values supplied to the statement.

Output

Field	Required	Description
Output	Optional	The result of the statement.