🔥 3-day streak
Snowflake SnowPro Core (COF-C03)21 / 148
Question 21 of 148

A data engineer runs a COPY INTO command to bulk load 50 CSV files from a named internal stage into a target table. Several rows across multiple files contain formatting errors that will cause parsing failures. The business requirement is that all valid rows must be loaded, and only the individual problematic rows should be skipped without aborting the load. Which ON_ERROR option should be specified in the COPY INTO command?

Reviewed for accuracy · Report an issueNext question