Options tab

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15


Options tab

Use the options in this tab to define how the data is loaded using the Snowflake COPY INTO command:

Option Description
Truncate table Select to remove all the data in the table before bulk loading the current data. When the Truncate table option is cleared, the data is appended during a new data load (default).
On error Select one of the following values to indicate what to do if an error occurs during the bulk load:
  • Abort: Stops loading data into the warehouse.
  • Skip file: Skips loading the file that caused the error and continues processing.
  • Skip file number: Number of errors that can occur before the file is skipped in the loading process.
  • Skip file percent: Percentage of errors in the record count that can occur before processing stops.
  • Continue: Ignore the errors and continues processing.
Skip file after (x) errors Enter the number of errors than can occur before the file is skipped in the loading process.

This field displays when the Skip file number field is selected.

Skip file after (%) errors Enter the percentage of errors than can occur before the file is skipped in the loading process.

This field displays when the Skip file percent field is selected.