ALTER MODEL MONITOR

Modifies the properties of a model monitor:

  • Suspends or resumes the monitor.

  • Sets the baseline table the monitor uses.

  • Sets the refresh interval for dynamic table operations within the monitor.

  • Sets the warehouse the monitor uses.

See also:

CREATE MODEL MONITOR, SHOW MODEL MONITORS, DESCRIBE MODEL MONITOR, DROP MODEL MONITOR

Syntax

ALTER MODEL MONITOR [ IF EXISTS ] <monitor_name> { SUSPEND | RESUME }

ALTER MODEL MONITOR [ IF EXISTS ] <monitor_name> SET
   [ BASELINE='<baseline_table_name>' ]
   [ REFRESH_INTERVAL='<refresh_interval>' ]
   [ WAREHOUSE=<warehouse_name> ]
Copy

Parameters

monitor_name

Specifies the identifier (i.e. name) of the model monitor.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

SET ...

Specifies one or more model monitor properties to be set.

BASELINE='<baseline_table_name>'

Sets the baseline table that the monitor uses.

WAREHOUSE = warehouse_name

Sets the warehouse that the monitor uses.

REFRESH_INTERVAL = 'refresh_interval'

The interval at which the monitor refreshes its internal state. The value must be a string representing a time period, such as '1 day'. Supported units include seconds, minutes, hours, days, weeks, months, quarters, and years. You may use singular (“hour”) or plural (“hours”) for the interval name, but may not abbreviate.

Access control requirements

A role used to execute this SQL command must have the following privileges at a minimum:

Privilege

Object

Notes

Any

Model monitor

The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Language: English