Set up a new dbt Project from Scratch: A Beginner’s Guide

Introduction

Want to start with dbt core but don’t know where to begin? Don’t worry! In this tutorial, we'll walk through setting up a new dbt project from scratch - we cover the entire process from creating a virtual environment to initializing your project and verifying the setup. Perfect for getting started quickly and smoothly with dbt.

✅ Prerequisites

Before you start, make sure you have:

• Python 3.7+ installed

1️⃣ Create a virtual environment

Create a new virtual environment in your project directory:

python3 -m venv venv

Activate the virtual environment:

source venv/bin/activate

2️⃣ Install dbt core

Install dbt Core inside your virtual environment using pip:

pip install dbt-core

Verify the installation:

dbt --version

If you’d like to dive deeper into dbt (data build tool), our book Building Modern Data Pipelines with dbt: From Raw Data to Gold Standard with the Medallion Architecture provides a hands-on guide to designing modern data pipelines. It covers dbt’s core concepts and best practices, including building Bronze, Silver, and Gold layers with the Medallion Architecture. It also serves as a hands-on study guide for the dbt Analytics Engineering Certification.

View on Amazon

3️⃣ Initialize the dbt Project

Navigate to the directory where you want to create your project, then run dbt init with the project name of your choice.