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 correct answer is C. RETURN_ERRORS. The RETURN_ERRORS value in the VALIDATION_MODE option of the COPY command instructs Snowflake to validate the data files and return errors encountered across all specified files, including those that were partially loaded during an earlier load.

Data Loading and Unloading

Question

Options

ARETURN_-1_R0WS
BRETURN_n_ROWS
CRETURN_ERRORS
DRETURN ALL ERRORS

How the community answered

(29 responses)

B
7% (2)
C
90% (26)
D
3% (1)

Explanation

The RETURN_ERRORS value in the VALIDATION_MODE option of the COPY command instructs Snowflake to validate the data files and return errors encountered across all specified files, including those that were partially loaded during an earlier load.

Topics

#Data Loading#COPY INTO#VALIDATION_MODE#Error Handling

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice