Loading Data Using COPY Command
This scenario describes a Job that loads data into a Snowflake table using the COPY
command, where Copy Command Options is customized in ON_ERROR form in
case any record is rejected.
The input data contains several records, one of which violates the length limitation.
#Name
Harry
veryveryveryLongName
JackThen, the input data is inserted into a Snowflake table and the record that violates the length limitation is rejected.