
Answer-first summary for fast verification
Answer: VALIDATE
The VALIDATE function is specifically designed to validate files loaded in a past execution of the COPY INTO command and returns all errors encountered during the load, rather than just the first error. This directly matches the question's requirement to view all errors from a previous data load. The community discussion shows 100% consensus on answer A with multiple users confirming that VALIDATE serves this exact purpose, and the Snowflake documentation link provided in the discussion supports this. Other options are incorrect: INFER_SCHEMA is for schema detection, GENERATOR is for generating sequences, and QUERY_HISTORY is for viewing query execution history.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.