Question 450
A COPY statement timed out and the engineer needs its query ID, execution status, and runtime. What history should they inspect?
Explanation
Correct Answer
Correct: SQL statement execution evidence. QUERY_HISTORY shows execution details for SQL statements.
Incorrect Answers
Not best here: COPY_HISTORY shows historical file-load activity and status for supported tables; the requested function is SQL statement execution evidence.
Not best here: PIPE_USAGE_HISTORY reports historical Snowpipe-related usage metrics; the requested function is SQL statement execution evidence.
Not best here: LOGIN_HISTORY records authentication attempts rather than ingestion operations; the requested function is SQL statement execution evidence.