Database
Last updated: 06 Jan 2023
Description¶
The Database Export node is used to export data into an external database.
Configuration Options¶
Basic Configuration Options¶
| Setting | Description\Parameters |
|---|---|
Database Connection |
The database to query against. These connections can be configured in the Databases dialog. |
Table Name |
Name of the table to create/update. |
Write Mode |
Mode in which to update the above table. Options include Recreate,Insert,Create,Truncate. |
Batch Commit |
Whether or not 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. If this index already exists in the table, it is overwritten. |
Columns |
Output columns to build the index on. |
Actions¶
| Action | Description |
|---|---|
Preview |
After configuring the node, the source data can be previewed by clicking the Preview button. If not using a data type template, be sure to Infer Data Types. |