Table activity

The Table activity automatically maps object properties from a previous activity to table columns with identical names, including a letter case. Therefore, each property must correspond to a column with an identical name and case. This forms a strict 1:1 mapping. To use different column names, you must include a Mapping activity. In this way, you can explicitly define how each property maps to a column and override the default behavior.

Without a separate Mapping activity, the Table activity relies on an automatic mapping. You must ensure these configurations are in place:

  • All required properties exist in the input.
  • Properties and corresponding table columns must have identical names.
  • Letter case is preserved because the mapping is case sensitive.

When you create a pipeline, the Table activity is placed on the canvas by default.

To configure the Table activity, perform these steps:

  1. Click the Table activity to expand the right panel.
  2. On the panel, select the destination table.
  3. In the Load behavior field, select Upsert or Insert.
  4. To close the panel, click Close.
  5. Click Save.