Schema:

ORGANIZATION_USAGE

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 accounts within the organization. It does not include resource monitors from reader accounts.

Columns¶

Organization-level columns

Column Name

Data Type

Description

ORGANIZATION_NAME

VARCHAR

Name of the organization.

ACCOUNT_LOCATOR

VARCHAR

System-generated identifier for the account.

ACCOUNT_NAME

VARCHAR

User-defined identifier for the account.

Additional columns

Column

Data Type

Description

RESOURCE_MONITOR_ID

NUMBER

System identifier.

NAME

VARCHAR

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

VARCHAR

Name of the role that owns 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.

WAREHOUSES

VARCHAR

Names of the warehouses that are associated with the resource monitor.

Usage notes¶

  • Latency for the view may be up to 24 hours.

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