Which of teh system tables will you use to create your query to get this information?

You are asked to find out the average number of queries run on an hourly basis to better understand query activity.

Which of teh system tables will you use to create your query to get this information?
A . QUERY_HISTORY
B. QUERY_LOG
C. QUERY_MONITOR

View Answer

Answer: A

Explanation

QUERY_HISTORY table in the ACCOUNT_USAGE schema will give you this information. Please try the below query

SELECT DATE_TRUNC(‘HOUR’, START_TIME) AS QUERY_START_HOUR,

WAREHOUSE_NAME,

COUNT(*) AS NUM_QUERIES

FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY

WHERE START_TIME >= DATEADD(DAY, -7, CURRENT_TIMESTAMP())

GROUP BY 1,2

ORDER BY 1 DESC, 2;