Answer-first summary for fast verification
Answer: Return to the worksheet and abort the query.
The question asks for the FASTEST way to cancel a single long-running query in Snowsight. Option B (Return to the worksheet and abort the query) is the most direct and immediate method, as it uses the built-in interface functionality of Snowsight itself. The community discussion strongly supports this with 100% consensus and upvoted comments emphasizing that going back to the worksheet and clicking 'Abort' is the quickest approach. Option D (Find the query in the query activity view and cancel) is possible but slower due to navigation steps. Option A (suspend the virtual warehouse) would affect all queries on that warehouse, not just the target query, and is inefficient. Option C (set auto_suspend to 0) is irrelevant to canceling a running query and could increase costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the fastest way to cancel a single long-running query that has been executing for over an hour in Snowsight, while other queries from different worksheets are completing successfully?
A
Immediately suspend the virtual warehouse that the query is running on.
B
Return to the worksheet and abort the query.
C
Set the auto_suspend virtual warehouse property to 0.
D
Find the query in the query activity view and cancel the query.