Meant for power users, this permission on a SQL warehouse is stronger than CAN USE but weaker than CAN MANAGE. It allows running queries and watching the warehouse, for example through its history of queries and their profiles.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains CAN MONITOR in context, with comparison tables and the common traps.
Terms in this definition
- SQL warehouse
Compute dedicated to running SQL queries, dashboards and BI tools, available as serverless, pro or classic. Serverless is the recommended type where offered, and every type runs Photon by default.
- MANAGE
A Unity Catalog privilege allowing a principal to grant and revoke access on an object, hand over its ownership and drop it, all without being the owner. It gives no data access by itself and is not part of
ALL PRIVILEGES. - Warehouse
Fabric item offering complete T-SQL support (DML, DDL, multi-table transactions) over Delta tables held in OneLake; lakehouse SQL analytics endpoints, by contrast, are read-only.
Related terms
- Query profile
A visual account of how a query ran, covering operators, time taken, rows and peak memory, used to track down bottlenecks. Viewing it requires owning the query or CAN MONITOR on the warehouse, and on serverless it stands in for the Spark UI.
- VMware vSphere
Virtualisation from VMware, in which ESXi hosts are managed by vCenter Server. Veeam ONE reads its inventory, events and performance so it can monitor the environment and produce reports about it.