
Answer-first summary for fast verification
Answer: OPERATE
The OPERATE privilege on a virtual warehouse is required to abort executing queries. According to Snowflake documentation and the community discussion with 100% consensus, the OPERATE privilege specifically enables users to change the state of a warehouse (stop, start, suspend, resume) and also allows viewing current and past queries while providing the ability to abort any executing queries. The USAGE privilege only allows using the warehouse for query execution but not managing it. MODIFY is for altering warehouse properties, and MONITOR is for viewing warehouse usage metrics but not for aborting queries.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.