A data engineer needs to load CSV files from an S3 stage into a Snowflake table. Some files contain rows that violate the table constraints. The engineer wants the load to continue for valid rows and skip invalid ones without failing the entire COPY INTO command. Which ON_ERROR option should be used?
This is a free preview. Create an account to access all 340 questions.