Continuous Data Pipelines and Dynamic Tables in Snowflake

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Snowflake offers powerful support for the construction of complex data pipelines. This support includes constructs such as dynamic tables, streams, and tasks. In this course, learn about continuous data pipelines in Snowflake, including Snowflake's support for continuous data loading and transformation, change data capture, and recurring operations, and configure dynamic tables to manage and automate these processes. Next, discover how to create and configure dynamic tables, set properties to control their behavior, and verify the change tracking property of base tables. Finally, explore how to connect and manage dependencies between dynamic tables, create dynamic tables that depend on other dynamic tables, ensure their refresh modes are compatible, and configure dynamic tables to refresh on demand. After completing this course, you will be able to describe continuous data pipelines and use and configure dynamic tables in Snowflake.