Streams and Change Data Capture in Snowflake

Snowflake    |    Intermediate
  • 11 videos | 1h 27m 48s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Streams are Snowflake's construct for change data capture (CDC) and process only changes in an underlying table or view. Used with dynamic tables and tasks, streams are an important and powerful building block of pipelines in Snowflake. In this course, learn about the usage and internal workings of streams for change data capture (CDC), stream types, and standard stream contents during insert, update, and delete operations. Next, discover how to create and read standard streams, combine stream contents with the target table for inserts and updates, and the effects of insert, update, and delete operations on standard stream contents. Finally, explore append-only streams, the relationship between streams and transactions, repeatable read isolations in streams, stream behavior within transactions, and how to implement streams on views. Upon course completion, you will be able to outline streams and change data capture in Snowflake.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline the usage and internal working of streams for change data capture (cdc)
    Compare stream types and identify the contents of a standard stream during insert, update, and delete operations
    Create a standard stream and analyze how it is updated when data is inserted into the base table
    Use variants of the merge into command to combine stream contents with the target table for inserts and updates
    Perform insert, update, and delete operations on standard stream contents
  • Create an append-only stream and analyze how it deals with insert, update, and delete operations on the base table
    Outline repeatable read isolations in streams
    Analyze the behavior of streams from within transactions
    Implement streams on views and analyze if they are working
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 29s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 46s
    Upon completion of this video, you will be able to outline the usage and internal working of streams for change data capture (CDC). FREE ACCESS
  • Locked
    3.  Stream Types and Functionality
    9m 8s
    In this video, compare stream types and identify the contents of a standard stream during insert, update, and delete operations. FREE ACCESS
  • Locked
    4.  Creating and Reading from Standard Streams
    11m 14s
    Find out how to create a standard stream and analyze how it is updated when data is inserted into the base table. FREE ACCESS
  • Locked
    5.  Leveraging MERGE INTO in Working with Streams
    11m 39s
    In this video, discover how to use variants of the MERGE INTO command to combine stream contents with the target table for inserts and updates. FREE ACCESS
  • Locked
    6.  Performing Insert, Delete, and Update Operations in Standard Streams
    10m 37s
    During this video, you will learn how to perform insert, update, and delete operations on standard stream contents. FREE ACCESS
  • Locked
    7.  Working with Append-only Streams
    8m 40s
    In this video, find out how to create an append-only stream and analyze how it deals with insert, update, and delete operations on the base table. FREE ACCESS
  • Locked
    8.  Streams and Transactions
    3m 21s
    After completing this video, you will be able to outline repeatable read isolations in streams. FREE ACCESS
  • Locked
    9.  Exploring Interactions between Transactions and Streams
    10m 52s
    In this video, analyze the behavior of streams from within transactions. FREE ACCESS
  • Locked
    10.  Implementing Streams on Views
    8m 26s
    During this video, discover how to implement streams on views and analyze if they are working. FREE ACCESS
  • Locked
    11.  Course Summary
    1m 37s
    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 Queries in Snowflake: Getting Started with Performance Optimizations
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Course Snowflake Performance: Iceberg Tables, External Tables, and Views
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Course Advanced Analytics: Performing Analytics Using Snowflake
Rating 4.6 of 48 users Rating 4.6 of 48 users (48)