From the course: End-to-End Data Engineering Project

Unlock the full course today

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

Initiating your dbt project

Initiating your dbt project

- [Instructor] Now that you have some context on dbt, let's go ahead and set up our project. But just a quick note before that, your repo has already been initialized for dbt, meaning it has all the files that it needs to get started. These files get created when you execute dbt init. The dbt init command also creates a profiles.yml file. This file describes a connection to our data platform and is one of the most important files in a dbt project. In this case, I have moved that file into the config directory to have it handy. Now let's go to Visual Studio Code to set up our project. Let's start by opening the profiles file. Since this file tells dbt how to connect to the data platform, in this case BigQuery, it may contain information that we don't want to version control. Because of that, we are going to use environment variables. As you can see, this profiles file is already prepared for that. Go to the terminal and…

Contents