From the course: Data Engineering: dbt for SQL

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Modeling in dbt

Modeling in dbt

From the course: Data Engineering: dbt for SQL

Start my 1-month free trial Buy for my team

Modeling in dbt

“

- [Instructor] We're going to be working with a MariaDB MySQL database for these exercises. Anytime you start a new project it's always important to get a lay of the land. In VS code, we can access our running MariaDB database right from the UI. To access it, click the database button on the left side panel. You can expand the database to see the tables and views present. Now let's install DBT. To install DBT from MariaDB, we're going to install the DBT MySQL package. Type, pip install dbt-mysql. Once you've installed the DBT MySQL package, let's create our first DBT project. For ease of use, we'll call the project 'Intro'. To create a new project, type dbt init. You'll be prompted to enter a project name. Let's type in intro. Then you'll be notified that the profile for intro already exists. We'll talk about profiles in a bit, but for now enter N for no. Great. We've just bootstrapped our first DBT project.…

Contents