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