Datasource Batch Create

Impure

Inserts data in batches into a SQL datasource.

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Complete

OUTPUT

Fires when the data is successfully inserted into the cube.

Data Inputs

Datasource

INPUT

Name of the datasource to use.

Table

INPUT

The name of the table to insert into.

Sample Row

INPUT

Optional sample row map, list of row maps, or datasource mapping; Map keys are used to infer field names if Fields input is not supplied.

Fields

INPUT

An list of field names to insert values into.

Update Fields

INPUT

Optional list of fields to update on duplicate key conflict.

Data Outputs

Batcher

OUTPUTstring

Unique Key of the created Batcher to be used in Insert/Update/Flush nodes.

Settings

Batch Size

INTEGER

How many inserts to batch together at a time.

Default: 200

Insert Mode

STRING

Insert strategy: plain INSERT, INSERT IGNORE, or INSERT ... ON DUPLICATE KEY UPDATE.

Default: INSERT

Options:

INSERTINSERT_OR_UPDATEINSERT_OR_IGNORE

Timeout

INTEGER

Connection timeout in seconds. 0 for no connection timeout.

Default: 0

Flush On Finish

BOOLEAN

Automatically flush the batcher when the process completes.

Default: true

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing