Schema:: READER_ACCOUNT_USAGE

RESOURCE_MONITORS view¶

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

Note

This view is only available in the READER_ACCOUNT_USAGE schema.

Columns¶

Column Name	Data Type	Description
READER_ACCOUNT_NAME	TEXT	Name of the reader account where the resource monitor was created.
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.
WAREHOUSES	TEXT	Names of the warehouses that are associate with the resource monitor.
NOTIFY	NUMBER	Percentage of the credit quota. When consumption reaches this threshold, notifications are sent.
SUSPEND	NUMBER	Percentage of the credit quota. When consumption reaches this threshold, assigned warehouses are suspended but currently running queries are allowed to complete.
SUSPEND_IMMEDIATE	NUMBER	Percentage of the credit quota. When consumption reaches this threshold, all assigned warehouses are suspended immediately, including those running queries.
LEVEL	TEXT	Indicates whether it is an account-level or a warehouse-level resource monitor.
READER_ACCOUNT_DELETED_ON	TIMESTAMP_LTZ	Time and date (in the UTC time zone) when the reader account is deleted.

Usage notes¶

Latency for the view may be up to 120 minutes (2 hours).

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