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 Jack
Then, the input data is inserted into a Snowflake table and the record that violates the length limitation is rejected.