Question

A data engineering team wants to be alerted when their dedicated warehouse consumes 80% of its monthly credit quota, but under no circumstances should Snowflake suspend the warehouse or block queries. They configure a resource monitor assigned to the warehouse with a monthly quota. Which trigger action configuration meets this requirement?

Accepted Answer

A single trigger at 80% with the NOTIFY action, and no SUSPEND or SUSPEND_IMMEDIATE triggers defined

Answer

A trigger at 80% with SUSPEND and a second trigger at 100% with SUSPEND_IMMEDIATE

Answer

A trigger at 80% with NOTIFY and a trigger at 100% with SUSPEND to enforce the quota ceiling

Answer

No resource monitor is needed; enabling account-level email notifications automatically alerts at 80% credit usage