Help Centre › Building Processes
Insert multiple rows into a table in batches.
Add it to a process
In the process designer, open the Add step tab. Find Bulk insert rows under Database › Bulk & Import/Export, or type its name in the search box, and drag it onto the canvas.
Fields
| Field | Required | What it does |
|---|---|---|
| Rows (JSON array of dictionaries) | Yes | The data variable containing the rows to insert |
| Variable | Yes | Name of the variable where the result will be stored Default: inserted_rows. |
| Connection name | Yes | Connection name |
| Table name | Yes | The database table name |
| Batch size | No | The number of rows to insert per batch Default: 1000. |
What it gives back
{inserted_rows}– Number of rows inserted
See all Database steps.
Errors
| Error | Description |
|---|---|
| Connection not found | No open connection exists with the specified name |
| Table not found | The specified table does not exist in the database |
| Column mismatch | The dictionary keys do not match the table columns |
Tips
- Adjust batch_size to balance memory usage and performance – smaller batches use less memory, larger batches are faster
- The keys in the first dictionary define the column mapping for all rows
- Use db-list-columns to verify column names before inserting