From the course: Data Engineering with dbt
Join today to access over 25,300 courses taught by industry experts.
Medallion architecture: Bronze data - Data Build Tool (dbt) Tutorial
From the course: Data Engineering with dbt
Medallion architecture: Bronze data
- [Instructor] So, we're now ready to finally build our DBT project and we're going to start with our bronze data. Now, bronze data should be in a mostly raw state, where minor transformations are made to make it easier to manage data within your analytical database. For our use case, we're going to take a subset of the parking violation data columns. We should have the following tables added to our database when we're done: bronze parking violation codes and bronze parking violations. To do this, we're going to create a new folder within our models directory called bronze. We're first going to make sure we're in the NYC parking violations folder. And now, we're going to make a bronze folder within the models directory with the CLI command, make directory, so mkdir models bronze. And now, we can see in our folder, we now have a bronze, but it's completely empty. And so now we need to create our SQL files for our model. To…
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.