From the course: Data Engineering with dbt
Join today to access over 24,900 courses taught by industry experts.
Medallion architecture: Silver data - Data Build Tool (dbt) Tutorial
From the course: Data Engineering with dbt
Medallion architecture: Silver data
- [Instructor] This is video 0703. We've created our bronze data, and we're now ready to move on to our silver data in our medallion architecture. Silver data should align with your established data model for your analytical database. While data modeling is extremely important in data engineering, that is not the goal of this tutorial. Instead, we're just going to do some simple transformations and make it easier to do our metrics later on. The four tables we're going to be creating is silver parking violation codes, silver parking violations, silver violation tickets, and silver violation vehicles. Again let's make sure we are in our NYC parking violations folder for dbt, and similar to we did in bronze, we're going to make a directory called models/silver. And again we can see it here, blank directory, and we're going to use touch to create four files, touch models/silver/silver_parking_violation_codes, touch…
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.