Snowflake
COF-R02 · Question #261
What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));
The correct answer is D. To return errors from the last executed COPY command into table t1 in the current session. See the full explanation below for the reasoning.
Question
What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));
Options
- ATo validate external table files in table t1 across all sessions
- BTo validate task SQL statements against table t1 in the last 14 days
- CTo validate a file for errors before it gets executed using a COPY command
- DTo return errors from the last executed COPY command into table t1 in the current session
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D83% (20)
Community Discussion
No community discussion yet for this question.