Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?

The VALIDATIONMODE copy option is used to validate data files before loading. The RETURNALLERRORS value specifically instructs the COPY command to scan all specified files and return a complete list of errors found across all of them. This mode does not stop after encountering the first error in a file, which fulfills the requirement to find errors "across the files". This is particularly useful for a comprehensive validation of a large batch of files, including those that may have been partially loaded in a previous attempt.

A. RETURN-1R0WS: This is not a valid value for the VALIDATIONMODE parameter. The syntax is incorrect.
B. RETURNnROWS: This value only validates the first 'n' rows of data. It is used for sampling and does not return all errors across all files.
C. RETURNERRORS: This value aborts the validation process on the first error encountered within a file, so it does not guarantee returning all errors from across all specified files.

1. Snowflake Inc. Documentation. (2024). COPY INTO \

Reference Detail: The documentation explicitly states: "RETURNALLERRORS: Validates the data files specified in the COPY statement and returns all errors, across all files." It also clarifies that "RETURNERRORS ... aborts on the first error encountered in a file." This directly supports why D is correct and C is incorrect for the given scenario.