Delete Node

D

Data/Database/Delete

Delete rows from a database table and return the removed rows

filter_delete_local_dbdata

Inputs4

Outputs4

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

4

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

SQL Filter

String

filter

Optional SQL filter on the table's columns; leave empty to delete all rows. Use $name for a value that comes from a wire — `id = $id` mints a `$id` pin, and the value is bound as a literal instead of being pasted into the predicate.

Params

Struct

params

Values for the filter's $placeholders, as an object keyed by placeholder name without the $ (e.g. {"customer_id": 42}). Only needed when the filter itself comes from a wire — a literal filter derives one pin per placeholder instead. Where both supply the same name, the derived pin wins unless it is empty.

Schemaobjectobjectobject0 fields

No named fields in this schema.

Default {}

Output Pins

4

Write State

String

write_state

pending means durable on this device and awaiting cloud replay; buffered means process-local batching; applied means the configured store accepted the write

Operation ID

String

operation_id

Durable offline operation ID, or empty when this write has no offline receipt. For chunked imports this is the last accepted chunk.

Created Database

Execution

exec_out

Done Creating Database

Deleted Values

Struct Array

deleted_values

Rows that were deleted

Schemaobjectobjectobject0 fields

No named fields in this schema.

Node Info

Internal name

filter_delete_local_db

Category

Data/Database/Delete

Version

4