snowflake-webhooks-events

# Snowflake Webhooks & Events ## Overview Snowflake uses alerts, email notifications, external functions, and notification integrations for event-driven patterns (not traditional webhooks). ## Prerequisites - ACCOUNTADMIN or role with `CREATE ALERT` privilege - Email notification integration configured - For external functions: API Gateway (AWS/GCP/Azure) configured - For S3/GCS event notifications: Snowpipe configured ## Instructions ### Step 1: Snowflake Alerts (Built-in Event System) ```sql -- Alert when daily revenue drops below threshold CREATE OR REPLACE ALERT revenue_drop_alert WAREHOUSE = ANALYTICS_WH SCHEDULE = '60 MINUTE' IF (EXISTS ( SELECT 1 FROM daily_order_metrics WHERE metric_date = CURRENT_DATE() AND total_revenue < ( SELECT AVG(total_revenue) * 0.5 FROM daily_order_metrics WHERE metric_date BETWEEN DATEADD(days, -30, CURRENT_DATE()) AND DATEADD(days, -1, CURRENT_DATE()) ) )) THEN CALL SYSTEM$SEND_EMAIL( 'revenue_notifications', 'oncall@company.com', 'Revenue Alert: Below 50% of 30-day average', 'Daily revenue has dropped significantly. Check dashboard.' ); ALTER ALERT revenue_drop_alert RESUME; -- Alert when warehouse credits exceed daily budget CREATE OR REPLACE ALERT credit_usage_alert WAREHOUSE = ANALYTICS_WH SCHEDULE = '30 MINUTE' IF (EXISTS ( SELECT 1 FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY WHERE start_time >= CUR...