Snowpro Core · Free Practice Question Medium
Question 70
You need to see the history of all queries executed in the last 60 minutes. Which of the following method should you use?
- A Request Snowflake support to provide query history
- B Use the QUERY_HISTORY view in the ACCOUNT_USAGE schema
- C View the historical queries using the query history page
- D Use the QUERY_HISTORY table function in the INFORMATION schema
Reveal correct answers
Correct answers: C, D
Explanation
The QUERY_HISTORY table function in the INFORMATION schema provides up-to-date information without latency. The QUERY_HISTORY view in ACCOUNT_USAGE schema can have 3 hours of latency, so it will not be suitable for viewing the last 60 minutes of query history. The query history page can also be used to view the history of executed queries with-in the last 14 days.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
