1. Component library
  2. Write
  3. Create staging table

Create staging table

Write data to DataCleaner's embedded staging database (based on H2), which provides a convenient location for staging data or simply storing data temporarily for further analysis.

Analyzer Alias: Write to Datastore

Result metrics (WriteDataResult)

  • Errornous rows

    Not parameterized

  • Inserts

    Not parameterized

  • Updates

    Not parameterized

Configured properties

  • Datastore name

    String Required

  • Table name

    String Required

  • Write mode

    Determines the behaviour in case of there's an existing datastore and table with the given names.

    Choice: TRUNCATE NEW_TABLE Required

  • Columns

    List of InputColumn<Object> Required

  • Fields

    List of String Mapped with Columns Optional