Contents x
    Database
    • 06 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Database

    • Updated on 06 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Description

    The Database Export node is used to export data into an external database.


    Configuration Options

    Basic Configuration Options

    SettingDescription\Parameters
    Database ConnectionThe database to query against. These connections can be configured in the Databases dialog.
    Table NameName of the table to create/update.
    Write ModeMode in which to update the above table. Options include Recreate,Insert,Create,Truncate.
    Batch CommitWhether or not to commit to the database in batches.
    Batch Commit SizeSize of the batches to commit.

    Advanced Configuration Options

    Create an index on the output table on selected column(s)

    SettingDescription
    IndexName of the index to create. If this index already exists in the table, it is overwritten.
    ColumnsOutput columns to build the index on.

    Actions

    ActionDescription
    PreviewAfter 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.
    Was this article helpful?
    What's Next