You are using Snowsight to monitor a data pipeline that involves several tasks chained together using 'AFTER' dependencies. One of the intermediate tasks, is failing intermittently. Which of the…

Question

Options

• AThe Snowsight worksheet interface, by running SELECT statements on the underlying data in the
• BThe task history view in Snowsight, focusing on the execution details, error messages, and query
• CThe data lineage feature in Snowsight to visualize the data flow and dependencies between the
• DThe Resource Monitor page to see if warehouses are being over utilized and impacting all
• EThe role hierarchy page to see if the role executing the task has the correct privileges.

• B
  75% (18)
• C
  8% (2)
• D
  4% (1)
• E
  13% (3)

Explanation

Option B - the Snowsight task history view - is the most targeted tool for this scenario. It shows per-execution details including error messages, query IDs, execution durations, and links to query profiles, enabling root cause analysis of why a specific task run failed. For intermittent failures, comparing successful vs. failed runs side by side in the history is invaluable. It also shows downstream task states, revealing the blast radius of the failure. Option A (running SELECT queries on data) investigates data correctness, not task execution failures. Option C (data lineage) shows dependencies but not execution errors. Option D (Resource Monitor) shows warehouse-level utilization, not task-specific failure reasons. Option E (role hierarchy) is relevant only for permission errors, not intermittent failures.

No community discussion yet for this question.