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

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.

Back to top