Create a dbt Project From Scratch w/ Claude Code

Get all of my free resources to help you learn: https://skool.com/moderndata/about Work with me to modernize your data architecture: https://bit.ly/kdsconsulting ----- Using AI tools just for the sake of using AI isn't very helpful. If anything, it'll just help you hurry up to make a mess. But of course there are some nice use cases for us data folks that we shouldn't ignore. For example, working with code base tools like dbt. So in today's video, I'll walk through a simple example of how you can create a new dbt project from scratch, using Claude Code. We'll cover things like: Using the CLAUDE.md file to clarify the project purpose & design How uploading a sample dbt project can help the AI and get you a better result Creating "rules" to continuously improve long-term To be clear, this doesn't mean that you'll never have to review code or double check the work. Blindly trust the AI outputs at your own risk. But if you want to expedite some of the grunt work, this will help you get from zero to one a lot faster. And help set foundations for a well structured, clean project going forward. Enjoy! Timestamps: 00:00 Intro 00:35 Download Free Resources 00:57  Starting From Scratch 01:36 Creating a new dbt Project 05:30 Checks 07:07 Credentials (.env) 07:18 Review Project 08:17 Add Credentials 10:19 Create Sample Model 11:51 Claude Rules