Using Tasks and Architecting Snowflake Data Pipelines

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Tasks are Snowflake constructs that can execute code on a fixed schedule or when a stream has data to consume. Tasks are similar to cron jobs but are more complex because they can be chained into complex dependency networks called task graphs. In this course, learn about continuous data processing tasks, create and execute scheduled serverless and user-managed scheduled tasks, and implement task graphs and child tasks. Next, use dummy root nodes to bypass Snowflake's root node restrictions, create and use triggered tasks, and construct an architecture that utilizes streams, tasks, stages, and dynamic tables to feed into a dynamic dashboard. Finally, discover how to implement data pipelines with a stage, scheduled task, and table, add dynamic pipelines and triggered tasks to data pipelines, and create dashboards in Snowflake to consume data from different tables. Upon completion of this course, you will be able to use tasks and architect Snowflake data pipelines.