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.
For more technologies supported by Talend, see Talend components.
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.