RESOURCE_MONITORS view¶

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

This Organization Usage view displays the resource monitors that have been created in the reader accounts managed by an account.

Columns¶

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization.
ACCOUNT_LOCATOR	VARCHAR	System-defined identifier for an account.
ACCOUNT_NAME	VARCHAR	User-defined identifier for an account.
RESOURCE_MONITOR_ID	NUMBER
NAME	TEXT	Name of the resource monitor.
CREATED	TIMESTAMP_LTZ	Date and time when the resource monitor was created.
CREDIT_QUOTA	VARIANT	Monthly credit quota for the resource monitor.
USED_CREDITS	VARIANT	Number of credits used in the current monthly billing cycle by all the warehouses associated with the resource monitor.
REMAINING_CREDITS	FLOAT	Number of credits still available to use in the current monthly billing cycle.
OWNER	TEXT	Name of the role that owns the resource monitor.
NOTIFY	NUMBER
SUSPEND	NUMBER
SUSPEND_IMMEDIATE	NUMBER
WAREHOUSES	TEXT	Names of the warehouses that are associate with the resource monitor.

The view only displays objects for which the current role for the session has been granted access privileges.