Which are the valid options for the validation_mode parameter in the COPY command

Which are the valid options for the validation_mode parameter in the COPY command
A . RETURN_<n>_ROWS
B. RETURN_ERROR
C. RETURN_ERRORS
D. RETURN_ALL_ERRORS

View Answer

Answer: A, C, D

Explanation

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified: Supported Values

Notes

RETURN_n_ROWS (e.g. RETURN_10_ROWS)

Validates the specified number of rows, if no errors are encountered; otherwise, fails at the first error encountered in the rows.

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.

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#optional-parameters