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?
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 VALIDATION_MODE value RETURN_ALL_ERRORS returns all errors across all files specified in the COPY command, including files that were partially loaded during an earlier load because the ON_ERROR copy option was set to CONTINUE during the load.
RETURN_ALL_ERRORS Returns all errors across all files specified in the COPY statement, including files with errors that were partially loaded during an earlier load because the ON_ERROR copy option was set to CONTINUE during the load. D
RETURN_ERRORS Returns all errors (parsing, conversion, etc.) across all files specified in the COPY statement. RETURN_ALL_ERRORS Returns all errors across all files specified in the COPY statement, including files with errors that were partially loaded during an earlier load because the ON_ERROR copy option was set to CONTINUE during the load.
D RETURN_ALL_ERRORS Returns all errors across all files specified in the COPY statement, including files with errors that were partially loaded during an earlier load because the ON_ERROR copy option was set to CONTINUE during the load. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table
Should be C. The VALIDATION_MODE=RETURN_ALL_ERRORS parameter returns all errors across all files specified in the copy command statement. VALIDATION_MODE=RETURN_ERRORS: Returns all errors across all files in the COPY command, including files that were partially loaded during an earlier load.