A data engineering team is loading data from a CSV file containing customer information into a Snowflake table. The CSV file occasionally contains malformed data, such as missing fields or fields with incorrect data types (e.g., a string in a numeric field). The team wants to ensure that the loading process continues even when such errors occur, and that the problematic records are tracked for later analysis. Which of the following COPY INTO options should be used to achieve this, and how should the error be handled?
Correct Answer: E
'ON_ERROR = 'CONTINUE'` ensures that the load continues despite errors.
'VALIDATION_MODE = RETURN_ERRORS' allows you to retrieve details about the errors using the RESULT SCAN' function, which can then be stored in a separate error table. This allows for later analysis of problematic records. = FALSE is necessary if the column count varies between input records.