Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/task_error_notifications.sql

Created February 10, 2024 09:51
Show Gist options
  • Save vvgsrk/cbabb6977bbea59f98eb54ae4e060874 to your computer and use it in GitHub Desktop.
Save vvgsrk/cbabb6977bbea59f98eb54ae4e060874 to your computer and use it in GitHub Desktop.
Download ZIP
Snowflake task error notifications
Raw
task_error_notifications.sql
CREATE OR REPLACE NOTIFICATION INTEGRATION TASK_ERROR_NOTIFICATIONS
ENABLED = true
TYPE = QUEUE
NOTIFICATION_PROVIDER = AWS_SNS
DIRECTION = OUTBOUND
AWS_SNS_TOPIC_ARN = 'arn:aws:sns:eu-central-1:123456789012345:dp-tools-slack-notifier-alarm'
AWS_SNS_ROLE_ARN = 'arn:aws:iam::123456789012345:role/dp-tools-snowflake-tasks-error-notifications';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment