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)