SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ44

VerifiedData Storage and Processing

Three tables (A, B, and C) are populated by INSERT statements. Each INSERT statement runs in its own Snowflake task: TASK_A, TASK_B, or TASK_C. All tasks are scheduled to execute daily at the same time. TASK_C has the longest average execution time.

How can an Architect create an aggregated data object from a join of tables A, B, and C?

Explanation

Snowflake materialized views do not support joins. A child task with TASK_A, TASK_B, and TASK_C as predecessors starts only after all those predecessor tasks finish successfully, ensuring that the target-table join uses the completed daily loads from all three tables.

Learn more

Community Discussion

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