Skip to main content

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
Jack

Then, the input data is inserted into a Snowflake table and the record that violates the length limitation is rejected.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!