You are using Snowsight to monitor the performance of several queries. You notice a query that took significantly longer than expected. Which of the following actions, available directly within the Sn

Question

Options

• AExamine the SQL text of the query and identify potential areas for optimization based on syntax.
• BReview the 'Query Profile' to identify specific execution stages that consumed the most resources.
• CCheck the 'Warehouse Load' graph to see if the warehouse was under heavy load during the
• DAnalyze the 'Compilation Time' to determine if query compilation contributed significantly to the
• EDownload the query results to your local machine for further analysis.

• A
  9% (3)
• B
  79% (26)
• E
  12% (4)

Explanation

When diagnosing a slow query in Snowsight's Query History Details panel, the three most useful tools are: (B) the Query Profile, which visualizes execution stages as a tree/graph and highlights which operators consumed the most time, bytes, and rows - making it the primary diagnostic tool for slow queries; (C) the Warehouse Load graph, which shows historical warehouse utilization during the query's execution window, revealing whether resource contention from concurrent queries caused queuing or throttling; and (D) Compilation Time, which is broken out separately and can indicate that complex query logic or insufficient metadata caching added significant overhead before execution even began. Option A (reviewing SQL syntax) is a general optimization approach, not a Snowsight panel feature for diagnosing runtime behavior. Option E (downloading results) provides no diagnostic insight into execution performance.

No community discussion yet for this question.