But he wants to view all errors in the files along with Load status, how he can check all errors?

Marko, a Data Engineer is using Snowpipe for data loading in micro batches for one of the Finance Data workloads. There are set of files he attempted to load into the snowflake table using Snow-pipe. While monitoring he found that there are set of files has multiple issue, He queried the COPY_HISTORY view & checked the STATUS column which indicates whether a particular set of files was loaded, partially loaded, or failed to load.

But he wants to view all errors in the files along with Load status, how he can check all errors?

A. He can check RETURN_ALL_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason and view all errors in the files.

B. He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_ERROR_MODE copy option set to RE-TURN_ALL_PIPE_ERRORS.

C. Marko can look out for FIRST_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason why a file partially loaded or failed for all the files.

D. He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS.

View Answer

Answer: C

Explanation:

To view details about the errors when loading data into Snowflake, Marko can refer to specific columns in the relevant views. Here’s how each option fares:

A. He can check RETURN_ALL_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason and view all errors in the files.

Incorrect. There isn’t a column named RETURN_ALL_ERROR_MESSAGE in the COPY_HISTORY view in Snowflake.

B. He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_ERROR_MODE copy option set to RETURN_ALL_PIPE_ERRORS.

Incorrect. There isn’t a VALIDATION_ERROR_MODE copy option or RETURN_ALL_PIPE_ERRORS value in Snowflake’s COPY INTO statement.

C. Marko can look out for FIRST_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason why a file partially loaded or failed for all the files.

Correct. The FIRST_ERROR_MESSAGE column in the COPY_HISTORY view provides the first error message (if any) for a file that partially loaded or failed.

D. He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS.

Incorrect. Snowflake’s COPY INTO command does not have a VALIDATION_MODE option or a RETURN_ALL_ERRORS value.

Therefore, the correct answer is:

C. Marko can look out for FIRST_ERROR_MESSAGE column in the COPY_HISTORY view which can provide a reason why a file partially loaded or failed for all the files.