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 24,900 courses taught by industry experts.

Create View 1 in the Gold layer

Create View 1 in the Gold 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 View 1 in the Gold layer

“

- Now, we have the clean and transform data available in our single layer table. It's time to create a meaningful views around it, which can be directly used for some kind of reporting or analysis purpose. So, let's create our first gold layer view. I create a new sheet. I renamed this to gold layer view one. Now, I want it to analyze the daily sales data, so I'm creating a one view for the same, and that view would look something like this. So here, I wanted to identify what are the different types of product every user are buying in, in a specific category and on a specific date. So, I did this by combining these three tables for order product and customer and grouping based on these columns. Let us execute this, and our view got created successfully. Once the view got created, let's just see the output to get an idea how this looks like. Now looking at this view, you can do a lot of daily analysis for your sales. We can got the total quantity for every customer sales, the average…

Contents