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

PreviousPROCEDURENextROW ACCESS POLICY

Last updated