SnowDDL
Search
K
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. 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. 2.
    Comments for resource monitors are not supported by Snowflake.