Streams and Change Data Capture in Snowflake

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.