Question list
List of questions
Related questions
Question 35 - DEA-C01 discussion
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.
Previous
Next
Your answer:
0 comments
Sorted by
Leave a comment first
