snowflake-webhooks-events

Featured

Implement Snowflake event-driven patterns with alerts, notifications, and external functions. Use when setting up Snowflake alerts, email notifications, external API calls, or event-driven pipelines triggered by Snowflake data changes. Trigger with phrases like "snowflake alerts", "snowflake notifications", "snowflake events", "snowflake external function", "snowflake email".

AI & Automation 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# 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...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category