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.
Using the dbt CLI commands - Data Build Tool (dbt) Tutorial
From the course: Data Engineering with dbt
Using the dbt CLI commands
- [Instructor] Now that we've created our first DBT model, we can actually run it through the DBT project finally. There's three main command line commands that you use: DBT debug, which you've used before, DBT compile and DBT run. Let's quickly run through what those are. So let's first do DBT debug. Now, I'm going to intentionally create an error 'cause this is something that's very common that pops up when people learn DBT. As you can see, I do DBT debug, but it's saying two checks failed. Why is that happening when it worked not too long ago? Well, if you remember we have to be in the DBT directory. So LS. We're not in the DBT directory, so we are going to do CD NYC parking violations. And now when we run DBT debug again it should be happy. All checks pass, which is great. Now, the next command I want to introduce is DBT compile. Now, DBT compile runs all the DBT models end-to-end, but doesn't execute the model SQL…
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.