From the course: End-to-End Real-World Data Engineering Project with Databricks
Join today to access over 24,100 courses taught by industry experts.
Create the Silver layer database
From the course: End-to-End Real-World Data Engineering Project with Databricks
Create the Silver layer database
- [Instructor] Now it's time to create our second layer that is silver layer database. For that, let's quickly go to the new notebook. Give the name of a notebook at Silverlayer_DB and let's just quickly write our Spark SQL command. That's create database globalretail_silver, and also add the condition as create database, if not exist, and execute. This will going to create our globalretail_silver layer. If you want to just check it, just simply use percent SQL and say show databases. And this will show you all the databases. And in that you can see globalretail_silver database.
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 database1m 8s
-
(Locked)
Create a Databricks notebook to load the Silver layer: Customer delta table15m 19s
-
(Locked)
Create a Databricks notebook to load the Silver layer: Product delta table8m 39s
-
(Locked)
Create a Databricks notebook to load the Silver layer: Order delta table6m 1s
-
(Locked)
-
-
-