ANOMALY_INSIGHTS!LIST_MONITORS

Returns every anomaly monitor defined in the current account, along with each monitor’s configuration.

Syntax

SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!LIST_MONITORS()

Arguments

None.

Output

Returns a table with one row per monitor, with the following columns:

Column nameData typeDescription
ALIASVARCHARName of the monitor.
CONFIGVARIANT

The monitor’s persisted configuration. For the keys this object contains, see Monitor configuration.

Access control requirements

Users with any of the following roles can call this method:

  • ACCOUNTADMIN system role
  • GLOBALORGADMIN system role
  • SNOWFLAKE.APP_USAGE_ADMIN application role
  • SNOWFLAKE.APP_USAGE_VIEWER application role

Usage notes

  • Rows are sorted by name in ascending order, without regard to case.
  • If the account has no monitors, the method returns an empty result, which isn’t an error.
  • To return the configuration for a single monitor, use ANOMALY_INSIGHTS!GET_MONITOR_CONFIG.

Example

List all monitors in the current account:

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!LIST_MONITORS();