From the course: Data Engineering with dbt

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Create your first dbt model file

Create your first dbt model file - Data Build Tool (dbt) Tutorial

From the course: Data Engineering with dbt

Start my 1-month free trial Buy for my team

Create your first dbt model file

“

- [Instructor] We're now going to create our first DBT model. When we ran DBT in it, it create two example DBT models within the directory. NYC parking violations models example. So I'm going to show that to you over here on the left. Clicking over, you can see these files. We're now going to delete them. We don't really need them. They're going to make things a little bit more confusing, so I'm going to delete them permanently. Perfect, now with the empty blank models, we can now create our own SQL files. So remember again, we're going to do CD NYC parking violations, and we're going to go down further directory and go to models. Once again, we're going to create a new file called First Model. So touch first model.sql and we now have our first model here. This model is essentially just a SQL file. DBT sees a SQL file and runs it through our system. We're going to do a very simple SQL query just for our first model, so…

Contents