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 Gold layer demo table

Create the Gold layer demo table - 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 Gold layer demo table

“

- [Instructor] Before going to create our gold layer views, let's just see if we get the data into our bronze layer and silver layer. If we expand, let me refresh this and expand, and see these tables does not have the data. I can see RAW_ORDER and PRODUCT have data, but CUSTOMER does not have any data. Let's just quickly check. Select * from, I'm just changing the default schema to BRONZE and just say raw_customer. Now if I just see this, I don't see any data in the customer table. The reason being is the customer task might not have executed. Now if you don't want to wait for your task execution time to come, you can manually execute it. How? Let's just get the task name, say show tasks, you get the task name, copy the task name, and just say execute task and give the task name. Now once you execute in this manner, the task will going to get executed immediately, and this task will go and copy the data for any file available in our customer folder. Now let me just rerun this select…

Contents