Database Action
Overview
The Database Action node provides full CRUD (Create, Read, Update, Delete) operations against connected databases. It supports both Vantage internal tables and external database connections, with batch processing, upsert logic, and transaction support.
Category
Data — data/databaseAction
Settings
| Setting | Type | Default | Description |
|---|---|---|---|
| operation | String | insert | insert, update, upsert, delete, bulk_insert, bulk_update, bulk_upsert, truncate |
| sourceMode | String | vantage | vantage or external — which database connection to use |
| table | String | — | Target table name |
| upsertKey | String | — | Column(s) to match for upsert operations |
| batchSize | Number | 500 | Rows per batch for bulk operations |
| returnInsertedIds | Boolean | false | Whether to return auto-generated IDs after insert |
Inputs & Outputs
- input1 — Upstream data (rows to insert/update/delete)
- output1 — Operation result (affected row count, inserted IDs)
- output2 — Error details (failed rows, constraint violations)
Use Cases
- Bulk import — Insert thousands of rows from a CSV import with batch processing
- Sync external data — Upsert records from an API into a Vantage table, matching on external ID
- Cleanup workflows — Delete records older than a threshold date