Insert into table
Insert records into a table in a registered datastore. This component allows you to map the values available in the flow with the columns of the target table, in order to insert these values into the table.
Analyzer
Concurrent Distributed
execution possible
-
Errornous rows
Not parameterized -
Inserts
Not parameterized -
Updates
Not parameterized
-
Additional error log values
Additional values to write to error log
List of InputColumn<Object> Optional -
Buffer size
How much data to buffer before committing batches of data. Large batches often perform better, but require more memory.
Choice: Huge (1M values) Large (100k values) Medium (10k values) Small (1000 values) Tiny (100 values) Required -
Column names
Names of columns in the target table.
List of String Mapped with Values Required -
Datastore
Datastore to write to
UpdateableDatastore Required -
Error log file location
Directory or file path for saving erroneous records
File Optional -
How to handle insertion errors?
Choice: Stop the job Save errornuos records to file Required -
Schema name
Schema name of target table
String Optional -
Table name
Table to target (insert into)
String Optional -
Truncate table
Truncate table before inserting?
boolean Required -
Values
Values to write to the table
List of InputColumn<Object> Required