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

Create the Gold layer schema in the database

Create the Gold layer schema in the database - 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 schema in the database

“

- [Instructor] Now it's time to create our gold layer schema. For that, let's create a new worksheet. We name it Gold_layer. And select the database as PACIFICRETAIL_DB, and SILVER as an schema. Now, to create a new schema that is gold layer, just run this command: Create schema if not exist, and execute. This will be going to create a gold schema for us. Now, before moving into the gold layer tables, we wanted to just see that if we got all our data into our silver tables or not. For that, let's just get into the next video.

Contents