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:
|
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. |