Free dbt Bootcamp (Ep. 2): Setup dbt-core (Data Build Tool) - For Mac/Linux

Описание: Love the bootcamp? Get even more with the dbt Masterclass:
Covering everything from foundational basics to advanced deployment strategies:
https://www.dbtmasterclass.io/product...

Free dbt Certification Practice Test:
Looking to test your dbt knowledge? Sign up for my free dbt certification practice exam here:
https://www.dbtmasterclass.io/product...

------

Welcome to Episode 2 of the dbt Bootcamp! In this video, we move beyond the fundamentals of dbt and focus on getting dbt Core configured locally on a Mac. By the end, you’ll have a fully working dbt project connected to BigQuery. We also discuss crucial setup steps like installing Homebrew, Python, pip, Git, and the Google Cloud SDK—so you’re ready for hands-on data modeling in upcoming episodes.

Timestamps
00:00 – Introduction & Recap
Quick overview of Episode 1 and why dbt matters.

00:22 – Overview of dbt Setup
Our main goal: configuring dbt locally so we can build and test models.

00:43 – Why Dependencies Matter
Essential tools you need before dbt will run.

01:18 – Tools We’ll Use
dbt Core, VS Code, Terminal, GitHub, and BigQuery (Mac vs. Windows note).

02:56 – Installing VS Code & Setting Up GitHub
Downloading VS Code, creating a GitHub account, and starting a new repo.

07:10 – Creating a Google Cloud Project
Setting up GCP and enabling BigQuery for dbt.

10:06 – Diving Into dbt Documentation
Why the official docs are critical for installation and troubleshooting.

12:57 – Python Virtual Environments
What they are, why they’re key, and how to create one on a Mac.

18:01 – Installing Homebrew & Python
Managing Python versions via Homebrew, plus verification.

26:03 – Installing pip & Verifying Installations
Installing pip with Python and checking setup integrity.

29:01 – Downloading & Configuring Google Cloud SDK
Authenticating locally so dbt can work with BigQuery.

37:06 – Installing Git via Homebrew
Local version control and syncing with GitHub.

42:40 – Installing dbt Core & BigQuery Adapter
Using pip to add dbt-core and dbt-bigquery in the virtual environment.

50:30 – Verifying dbt Installation
Confirming the dbt version and ensuring readiness.

51:19 – Initializing a New dbt Project
Running dbt init, setting up profiles.yml, and configuring BigQuery.

57:09 – Why We Choose OAuth Authentication
Comparing OAuth vs. Service Accounts for local development.

1:04:10 – dbt Debug & Typical Errors
Common pitfalls and how to resolve them.

1:06:13 – Next Steps
Recommended docs to read before next episode.



Subscribe
Don’t forget to subscribe—upcoming episodes will explore real data modeling examples and more ways to level up your analytics engineering skills!