DB Row Deleter

Deletes rows from a selected database table that match the specified filter criteria.
The filter criteria define an SQL WHERE clause using flat AND/OR logic. If no filter criteria are configured, all rows in the table will be deleted.
The node outputs a one-row status table with the number of deleted rows and any warning, and a pass-through DB Connection port for downstream nodes.

Options

Database name

The name of the database (or catalogue) to use.

Schema name

The database schema to read the table from. If not provided, the default schema of the database will be used.

Table name

Name of the database table to read data from. Must match the table name as it appears in the selected schema.

Mode

Controls the scope of the delete operation. Switch to "All rows" to truncate the entire table without configuring filter criteria.

• Matching rows: Delete only rows that match the configured filter criteria.
• All rows: Delete all rows in the table.

Match row if matched by

Match the row if all or any criteria match:

• All criteria: a row is matched if all of the criteria match (intersection of matches)
• Any criterion: a row is matched if at least one of the criteria matches (union of matches)

Filter criteria

The list of criteria to filter on before deleting rows.

• Filter column: The column on which to apply the filter.
• Operator: Select the filter operator to apply.
• Filter value: The value to compare the column against. The type of input depends on the selected column's data type.

Append status column (to KNIME table)

If selected, it adds an extra column to the output table. The status column is the number of rows affected by the SQL statement. A number greater than or equal to zero indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution. A value of -2 indicates that the command was processed successfully but that the number of rows affected is unknown.

Status column name

Name of the new status column.

Append error column (to KNIME table)

If selected, it adds an extra column to the output table. The error column shows a warning message, if any.

Error column name

The name of the error column.

Views

This node has no views

Workflows

• Databases_cleanupKNIME Hub

Links

• No links available

Developers