Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

The correct answer is D. VALIDATION_MODE. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html 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…

Data Loading and Unloading

Question

Options

ASTRIP_NULL_VALUES
BSKIP_BYTE_ORDER_MARK
CREPLACE_INVALID_CHARACTERS
DVALIDATION_MODE

How the community answered

(47 responses)

A
6% (3)
B
4% (2)
C
15% (7)
D
74% (35)

Explanation

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html 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

Topics

#COPY command#VALIDATION_MODE#data verification#staged loading

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice