DB Push

This node receives a dataframe table as input and inserts all data into a specified database.

The user must specify the destination table name, description and the primary key fields of the table. The database schema where the table should be inserted and the insert batch size.

In case this table does not exist, it will be created on the first node execution. If the destination table does exist then on node execution, existing records will be updated and new records will be appended to the existing table.

Need column-level control? DB Push performs automatic schema alignment based on column names. If you need explicit field-by-field mapping, data transformations, constant values, or scripted expressions per column, use the DB Table Push node instead — it provides a full visual mapper with support for multiple mapping types.