How to Setup DBT Cloud for Beginners (FREE)
🧠 Don’t miss out! Get FREE access to my Skool community — packed with resources, tools, and support to help you with Data, Machine Learning, and AI Automations! 📈 https://www.skool.com/data-and-ai-aut...
🚀 Hire me for Data Work: https://ryanandmattdatascience.com/da...
👨💻 Mentorships: https://ryanandmattdatascience.com/me...
📧 Email: [email protected]
🌐 Website & Blog: https://ryanandmattdatascience.com/
🖥️ Discord: / discord
📚 *Practice SQL & Python Interview Questions: https://stratascratch.com/?via=ryan
📖 *SQL and Python Courses: https://datacamp.pxf.io/XYD7Qg
In this comprehensive tutorial, I walk you through the entire process of setting up dbt Cloud and connecting it to BigQuery as your data warehouse. As a full-time data scientist who uses dbt Cloud daily at a fintech company, I know how valuable this tool is for building and maintaining data models that feed into analytics dashboards and reports.
This is the first video in a complete dbt Cloud series where I'm documenting my journey learning BigQuery while teaching you dbt fundamentals. Even though I typically work with Amazon Redshift, I wanted to use BigQuery for this series to explore a new platform alongside you. We start from absolute scratch – setting up a free dbt Cloud developer account, creating a BigQuery project with sample data, configuring service accounts with proper credentials, and connecting everything to GitHub for version control.
By the end of this tutorial, you'll have a fully functional dbt Cloud environment connected to BigQuery, complete with sample datasets including Jaffle Shop and Stripe data. You'll see your first dbt models run successfully and understand how to create branches, commit changes, and use the dbt Cloud IDE. Whether you're a solo developer or working at a company building out your data infrastructure, this step-by-step guide will get you started with dbt Cloud and BigQuery integration in under 15 minutes.
TIMESTAMPS
00:00 Introduction to DBT Cloud Series
01:00 Creating a DBT Cloud Account
02:15 Selecting Data Warehouse (BigQuery)
03:20 Setting Up Google Cloud & BigQuery
05:16 Creating BigQuery Project
06:02 Loading Sample Data
07:00 Creating Service Account & Credentials
08:10 Uploading Service Account to DBT
09:13 Setting Up GitHub Repository
10:21 Creating New GitHub Repository
11:00 Connecting GitHub to DBT Cloud
11:40 Initializing DBT Project
12:40 Committing Changes to GitHub
13:10 Creating Branches in DBT
14:04 Running First DBT Model
14:45 Verifying Models in BigQuery
OTHER SOCIALS:
Ryan’s LinkedIn: / ryan-p-nolan
Matt’s LinkedIn: / matt-payne-ceo
Twitter/X: https://x.com/RyanMattDS
Who is Ryan
Ryan is a Data Scientist at a fintech company, where he focuses on fraud prevention in underwriting and risk. Before that, he worked as a Data Analyst at a tax software company. He holds a degree in Electrical Engineering from UCF.
Who is Matt
Matt is the founder of Width.ai, an AI and Machine Learning agency. Before starting his own company, he was a Machine Learning Engineer at Capital One.
*This is an affiliate program. We receive a small portion of the final sale at no extra cost to you.