From the course: End-to-End Real-World Data Engineering Project with Snowflake

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Create the task to merge product changes in the Silver layer

Create the task to merge product changes in the Silver layer - Snowflake Tutorial

From the course: End-to-End Real-World Data Engineering Project with Snowflake

Start my 1-month free trial Buy for my team

Create the task to merge product changes in the Silver layer

“

- [Presenter] For the product table, let's see the transformations. So we want to have the price validation. That means if we have any price, let's set it to zero , because we cannot have a negative price. Same thing, we need to do it for the stock quantity, because stock quantity cannot be non-negative number. And if we have any rating, which is outside the zero or five, we need to cap it down. So let's just see how we do this transformations and load the data into our cellular layer table. Let's create a new worksheet. And I call it "Product_Transform." Select the database and the schema. And this is how we are going to write the stored procedure. So we call it merge product to silver. And we say that merge into product silver product table. And again, we are going to get the data from the product stream. So you can see that we are selecting the data from the product stream, which contains only the incremental records. Right. Now, we wanted to do the price transformation. So we did…

Contents