SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ35

VerifiedImplement Data Pipelines

A Data Engineer must monitor a continuous data pipeline that processes data. Data is ingested into Snowflake from an Amazon S3 bucket through a pipe, and then transformed through a series of tasks and streams. The pipeline sends notifications when data importation fails.

How should the Engineer add a notification to indicate a failure in a task used for data transformations?

Explanation

Snowflake sends task-failure notifications through a notification integration assigned with ERROR_INTEGRATION on the root task of a task graph. A queue notification integration configured for outbound AWS SNS provides the required delivery mechanism; failures in child transformation tasks are relayed through the root task’s configured error integration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!