Continuous Data Pipelines and Dynamic Tables in Snowflake

Snowflake    |    Intermediate
  • 8 videos | 1h 3m 28s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
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.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline snowflake's support for continuous data loading, continuous data transformation, change data capture, and recurring operations
    Identify how to use and configure dynamic tables in snowflake
    Create a dynamic table, configure the refresh_mode, and initialize properties
  • Verify the change tracking property of a base table and discover how turning it off impacts connected dynamic tables
    Create a dynamic table that depends on another dynamic table and ensure their refresh modes are compatible
    Configure a dynamic table to only refresh on demand
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 34s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 59s
    After completing this video, you will be able to outline Snowflake's support for continuous data loading, continuous data transformation, change data capture, and recurring operations. FREE ACCESS
  • Locked
    3.  Usage and Configuration of Dynamic Tables
    12m 8s
    Upon completion of this video, you will be able to identify how to use and configure dynamic tables in Snowflake. FREE ACCESS
  • Locked
    4.  Creating Dynamic Tables
    10m 7s
    In this video, find out how to create a dynamic table, configure the refresh_mode, and initialize properties. FREE ACCESS
  • Locked
    5.  Verifying Change Tracking Property of Base Tables
    8m 30s
    Learn how to verify the change tracking property of a base table and discover how turning it off impacts connected dynamic tables. FREE ACCESS
  • Locked
    6.  Connecting Dynamic Tables
    9m 26s
    During this video, discover how to create a dynamic table that depends on another dynamic table and ensure their refresh modes are compatible. FREE ACCESS
  • Locked
    7.  Configuring On-demand Refresh Based on Downstream Target Lags
    9m 7s
    In this video, you will learn how to configure a dynamic table to only refresh on demand. FREE ACCESS
  • Locked
    8.  Course Summary
    1m 39s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Prompt Engineering for Data: Basic Data Manipulation Using Generative AI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Visualizing Data for Impact: Introduction to Data Visualization
Rating 4.5 of 78 users Rating 4.5 of 78 users (78)
Course Snowflake Performance: Iceberg Tables, External Tables, and Views
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)