- Schema:
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 |
|
SUSPEND |
NUMBER |
|
SUSPEND_IMMEDIATE |
NUMBER |
|
LEVEL |
TEXT |
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.