Answer-first summary for fast verification
Answer: To return errors from the last executed COPY command into table t1 in the current session
The VALIDATE function with the JOB_ID => '_last' parameter is specifically designed to return all errors from the most recent COPY command execution into the specified table (t1) within the current session. This is confirmed by the Snowflake documentation referenced in the community discussion and the unanimous consensus among commenters. Option D correctly describes this functionality. Option A is incorrect because VALIDATE does not validate external table files across sessions. Option B is wrong as it refers to task SQL validation, which is unrelated. Option C is incorrect because VALIDATE validates past COPY executions, not files before execution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the purpose of the following SQL command?
SELECT * FROM TABLE(VALIDATE(t1, JOB_ID => '_last'));
SELECT * FROM TABLE(VALIDATE(t1, JOB_ID => '_last'));
A
To validate external table files in table t1 across all sessions
B
To validate task SQL statements against table t1 in the last 14 days
C
To validate a file for errors before it gets executed using a COPY command
D
To return errors from the last executed COPY command into table t1 in the current session
No comments yet.