Comment on page

RESOURCE MONITOR

Config path: /resource_monitor.yaml
Example:
test_res_monitor_1:
  credit_quota: 125
  frequency: monthly
  triggers:
    50: notify
    75: notify
    100: suspend
    110: suspend_immediate
Schema
{key} (ident) - name of resource monitor
{value} (dict)
credit_quota (int) - he number of credits allocated to the resource monitor per frequency interval
frequency (str) - MONTHLY | DAILY | WEEKLY | YEARLY | NEVER
triggers (dict)
{key} (int) - quota threshold in percent
{value) (str) - action to take when threshold was reached SUSPEND | SUSPEND_IMMEDIATE | NOTIFY
Usage notes
1.Setting custom START_TIMESTAMP and END_TIMESTAMP is currently not supported, since it will cause your config to depend on wall clock time. START_TIMESTAMP is automatically set to IMMEDIATELY on creation and on change of frequency of resource monitor.
2.Comments for resource monitors are not supported by Snowflake.
Links
​CREATE RESOURCE MONITOR​
​ALTER RESOURCE MONITOR​
​SHOW RESOURCE MONITORS​
​Parser & JSON Schema (GitHub)​
​

PROCEDURE

ROW ACCESS POLICY

Last modified 1yr ago