Set up error notifications for tasks

작업을 실행하는 동안 오류가 발생하거나 작업 그래프가 성공적으로 완료되면 Snowflake는 클라우드 메시징 서비스로 알림을 푸시할 수 있습니다. 알림은 작업이 SQL 코드를 실행할 때 발생한 오류를 설명하거나 성공적으로 완료된 작업 그래프를 식별합니다.

This topic explains how to configure notification support for tasks that use cloud messaging.

Snowflake task integration is implemented using notification integration objects, which provide an interface between Snowflake and third-party cloud message queuing services.

Snowflake guarantees at-least-once message delivery of notifications; that is, multiple attempts are made to deliver messages to ensure at least one attempt succeeds, which can result in duplicate messages.

The task notification feature is supported for both serverless tasks and user-managed tasks; that is, tasks that rely on a virtual warehouse to provide the compute resources.

Notifications rely on cloud messaging that uses one of the following services:

  • Amazon SNS(Simple Notification Service)

  • Microsoft Azure Event Grid

  • Google Pub/Sub

Currently, cross-cloud support isn’t available for push notifications. You must configure notification support for the messaging service that is provided by the cloud platform where your Snowflake account is hosted.

이메일 및 웹훅 알림 통합 유형은 작업 오류 알림에 지원되지 않습니다.

You can use the NOTIFICATION_HISTORY table function to query the history of notifications sent through Snowpipe. For more information, see NOTIFICATION_HISTORY.

To set up task notifications, complete the following steps:

  1. 알림을 받을 항목을 만들고 해당 항목에 대한 알림 통합을 설정합니다.

    자세한 내용은 해당 플랫폼의 지침을 참조하십시오.

  2. 오류 및 성공 알림에 알림 통합 기능을 사용하도록 작업을 만들거나 구성합니다.

    Configure a task to send error notifications 및 Configure a task to send success notifications 섹션을 참조하십시오.