Task trees and dependencies in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a task tree in Snowflake?

A task tree is a set of tasks organized in a hierarchy where tasks depend on each other. It helps automate and schedule complex workflows by running tasks in order based on their dependencies.

beginner

How do task dependencies work in Snowflake?

Task dependencies mean one task waits for another to finish before starting. This ensures tasks run in the right order, like steps in a recipe.

intermediate

What happens if a parent task in a task tree fails?

If a parent task fails, its child tasks do not run because their dependency was not met. This prevents errors from running tasks out of order.

intermediate

How can you create a task with dependencies in Snowflake?

You create a task and specify the parent task it depends on using the 'AFTER' keyword. For example, TASK B AFTER TASK A means B runs after A completes.

beginner

Why use task trees instead of independent tasks?

Task trees automate complex workflows by managing order and dependencies. This reduces manual work and errors, ensuring tasks run only when their prerequisites are done.

In Snowflake, what does the 'AFTER' keyword do when creating tasks?

A Sets a task to run after another task completes

B Deletes a task after it runs

C Runs tasks in parallel

D Schedules a task to run at a specific time

'AFTER' defines a dependency so the task runs only after the specified task finishes.

What happens to child tasks if their parent task fails in a Snowflake task tree?

A Child tasks are skipped

B Child tasks run in parallel

C Child tasks run before the parent

D Child tasks run anyway

Child tasks depend on the parent task's success, so they are skipped if the parent fails.

Why are task trees useful in Snowflake?

A They allow manual task execution

B They automate workflows with dependencies

C They delete old tasks automatically

D They speed up query performance

Task trees automate running tasks in order based on dependencies, simplifying complex workflows.

Which statement is true about task dependencies in Snowflake?

A Tasks without dependencies cannot run

B Tasks with dependencies run simultaneously

C Dependencies are ignored if tasks are scheduled

D A task can depend on multiple parent tasks

A task can depend on multiple tasks, meaning it waits for all parents to complete before running.

How do you define a task that runs after two other tasks complete?

A TASK C BEFORE TASK A, TASK B

B TASK C WITH TASK A AND TASK B

C TASK C AFTER TASK A, TASK B

D TASK C RUNS PARALLEL TASK A AND TASK B

Using 'AFTER TASK A, TASK B' means TASK C runs after both A and B finish.

Explain how task trees and dependencies help automate workflows in Snowflake.

Think about how tasks depend on each other like steps in a recipe.

Describe how to create a dependent task in Snowflake and what happens if the parent task fails.

Focus on task creation syntax and failure behavior.

Practice

1. What is the main purpose of creating a task tree in Snowflake?

easy

A. To organize tasks so they run in a specific order using dependencies

B. To store data in a hierarchical format

C. To create multiple independent tasks that run simultaneously

D. To backup data automatically

Solution

1. Step 1: Understand task trees concept

   Task trees are used to organize tasks so they run one after another based on dependencies.

2. Step 2: Compare options

   Only To organize tasks so they run in a specific order using dependencies describes organizing tasks with dependencies. Others describe unrelated concepts.

3. Final Answer:

   To organize tasks so they run in a specific order using dependencies -> Option A

4. Quick Check:

   Task trees = ordered tasks [OK]

Hint: Task trees control task order using dependencies [OK]

Common Mistakes:

• Confusing task trees with data storage
• Thinking tasks run independently without order
• Assuming task trees backup data

2. Which Snowflake command correctly sets a task to run after another task named task_A?

easy

A. ALTER TASK task_B SET BEFORE = task_A;

B. CREATE TASK task_B AFTER task_A;

C. ALTER TASK task_B SET AFTER = task_A;

D. ALTER TASK task_A SET AFTER = task_B;

Solution

1. Step 1: Recall syntax for setting dependencies

   Snowflake uses ALTER TASK task_name SET AFTER = other_task; to set dependencies.

2. Step 2: Check each option

   Only ALTER TASK task_B SET AFTER = task_A; matches correct syntax. The option using BEFORE has an invalid keyword. The CREATE TASK option uses AFTER incorrectly. The option altering task_A reverses dependency.

3. Final Answer:

   ALTER TASK task_B SET AFTER = task_A; -> Option C

4. Quick Check:

   SET AFTER syntax = ALTER TASK task_B SET AFTER = task_A; [OK]

Hint: Use ALTER TASK ... SET AFTER = task_name to link tasks [OK]

Common Mistakes:

• Using BEFORE instead of AFTER
• Trying to set dependency during CREATE TASK
• Reversing task order in dependency

3. Given the following tasks and dependencies:

CREATE TASK task_A WAREHOUSE = wh1 AS SELECT 1;
CREATE TASK task_B WAREHOUSE = wh1 AS SELECT 2;
CREATE TASK task_C WAREHOUSE = wh1 AS SELECT 3;
ALTER TASK task_B SET AFTER = task_A;
ALTER TASK task_C SET AFTER = task_B;

If you start task_A, which task runs last?

medium

A. task_A

B. task_B

C. All run simultaneously

D. task_C

Solution

1. Step 1: Analyze task dependencies

   task_B runs after task_A, and task_C runs after task_B, so order is task_A -> task_B -> task_C.

2. Step 2: Identify last task in sequence

   Since task_C depends on task_B, which depends on task_A, task_C runs last.

3. Final Answer:

   task_C -> Option D

4. Quick Check:

   Dependency chain ends with task_C [OK]

Hint: Follow AFTER links to find last task [OK]

Common Mistakes:

• Thinking tasks run in parallel
• Choosing the first task as last
• Ignoring dependency order

4. You have two tasks: task_X and task_Y. You want task_Y to run after task_X. Which command fixes this if task_Y currently runs before task_X?

medium

A. CREATE TASK task_Y SET AFTER = task_X;

B. ALTER TASK task_Y SET AFTER = task_X;

C. ALTER TASK task_Y SET BEFORE = task_X;

D. ALTER TASK task_X SET AFTER = task_Y;

Solution

1. Step 1: Identify correct command to set dependency

   To make task_Y run after task_X, use ALTER TASK task_Y SET AFTER = task_X;.

2. Step 2: Check incorrect options

   ALTER TASK task_X SET AFTER = task_Y; reverses order. ALTER TASK task_Y SET BEFORE = task_X; uses invalid BEFORE keyword. CREATE TASK task_Y SET AFTER = task_X; uses CREATE incorrectly.

3. Final Answer:

   ALTER TASK task_Y SET AFTER = task_X; -> Option B

4. Quick Check:

   SET AFTER fixes order [OK]

Hint: Use ALTER TASK task_Y SET AFTER = task_X to fix order [OK]

Common Mistakes:

• Using BEFORE keyword which is invalid
• Setting dependency on wrong task
• Trying to fix order with CREATE TASK

5. You have a task tree where task_1 runs first, then task_2 and task_3 run after task_1 in parallel, and finally task_4 runs after both task_2 and task_3. How do you configure task_4 to run only after both tasks finish?

hard

A. ALTER TASK task_4 SET AFTER = task_2, task_3;

B. ALTER TASK task_4 SET AFTER = task_2; ALTER TASK task_4 SET AFTER = task_3;

C. ALTER TASK task_4 SET AFTER = task_2 AND task_3;

D. ALTER TASK task_4 SET AFTER = task_2; ALTER TASK task_3 SET AFTER = task_4;

Solution

1. Step 1: Understand multiple dependencies syntax

   Snowflake allows setting multiple tasks in AFTER clause separated by commas to require all to finish.

2. Step 2: Evaluate options

   ALTER TASK task_4 SET AFTER = task_2, task_3; correctly sets task_4 to run after both task_2 and task_3. ALTER TASK task_4 SET AFTER = task_2; ALTER TASK task_4 SET AFTER = task_3; overwrites AFTER twice, only last applies. ALTER TASK task_4 SET AFTER = task_2 AND task_3; uses invalid AND keyword. ALTER TASK task_4 SET AFTER = task_2; ALTER TASK task_3 SET AFTER = task_4; reverses dependency.

3. Final Answer:

   ALTER TASK task_4 SET AFTER = task_2, task_3; -> Option A

4. Quick Check:

   Multiple AFTER tasks separated by commas [OK]

Hint: Use commas to list multiple tasks in SET AFTER [OK]

Common Mistakes:

• Using multiple SET AFTER commands overwriting each other
• Using AND instead of comma
• Setting wrong dependency direction