Database
Last updated: 13 Jan 2023
Description¶
The Database Export node exports data into an external database.
Configuration Options¶
Basic Configuration Options¶
| Setting | Description\Parameters |
|---|---|
Database Connection |
The database to query against. These connections are configured in the Databases dialog. |
Table Name |
Name of the table to create/update. |
Write Mode |
Table options are Recreate, Insert, Create, Truncate. |
Batch Commit |
Option to commit to the database in batches. |
Batch Commit Size |
Size of the batches to commit. |
Advanced Configuration Options¶
Create an index on the output table on selected column(s)
| Setting | Description |
|---|---|
Index |
Name of the index to create. Any existing table index will be overwritten. |
Columns |
Output columns to build the index on. |
Actions¶
| Action | Description |
|---|---|
Preview |
Once the node is configured, the source data can be previewed at any time. If not using a data type template, be sure to Infer Data Types. |