From the course: End-to-End Real-World Data Engineering Project with Snowflake
Join today to access over 24,900 courses taught by industry experts.
Create the stream in Snowflake to capture Product table changes - Snowflake Tutorial
From the course: End-to-End Real-World Data Engineering Project with Snowflake
Create the stream in Snowflake to capture Product table changes
- [Instructor] On similar lines, to identify the changes all the new rows got coming in in our product table, we need to create the stream for the product table as well. Now, to create the stream for the product table, we can just go and execute this query. Create or replace stream, and give the product stream name as product_changes_stream on table raw_product. So important clause here is, on table, which is saying that it is going to watch this raw_product table for identifying any new changes are coming in. Let's just execute this. And then, our product_changes_stream got created.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
(Locked)
Create the Silver layer schema in the database4m 15s
-
(Locked)
Create the stream in Snowflake to capture Customer table changes1m 38s
-
(Locked)
Create the stream in Snowflake to capture Product table changes52s
-
(Locked)
Create the stream in Snowflake to capture Order table changes1m 44s
-
(Locked)
Create the task to merge customer changes in the Silver layer7m 2s
-
(Locked)
Create the task to merge product changes in the Silver layer4m 15s
-
(Locked)
Create the task to merge order changes in the Silver layer2m 32s
-
(Locked)
-
-