Answer: QUERY_HISTORY

The QUERY_HISTORY view in the ACCOUNT_USAGE schema contains detailed information about all queries executed in Snowflake, including execution time metrics. This view includes columns like TOTAL_ELAPSED_TIME and EXECUTION_TIME that can be used to identify long-running queries by filtering for queries with high duration values. The community discussion with 100% consensus supports this answer, referencing the official Snowflake documentation for QUERY_HISTORY. Other options are less suitable: DATA_TRANSFER_HISTORY tracks data movement between regions, TASK_HISTORY monitors task executions, and METERING_DAILY_HISTORY provides daily usage metrics rather than individual query performance details.

Author: LeetQuiz Editorial Team