dbt(Data Build Tool) crash course for beginners: Zero to Hero

In this video tutorial, we will learn about dbt (data build tool), the core concepts of dbt, exploring its project structure and key components.
It will guide us through setting up dbt Cloud using BigQuery and GitHub. Additionally, the tutorial covers various topics of dbt such as models, building & running them, understanding Macros, Generic and Singular Tests, and Snapshots within dbt.

▬▬▬▬▬▬ Links 🔗 ▬▬▬▬▬▬

▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬
00:00 Getting Started (Understanding dbt and its role in the data life cycle)
08:50 dbt core concepts & project structure
13:13 Configuring dbt Cloud with BigQuery and Github Integration
26:32 yml files in dbt
31:28 Model Creation Process and Execution in dbt
50:03 Exploring Macros in dbt
59:04 Overview of Generic and Singular Testing in dbt with example
68:04 Utilizing Snapshots in dbt

#dbt
#databuildtool
#dbtcloud
#dbtlabs
#bigquery

dbt
data build tool
dbt cloud
dbt labs
BigQuery
dbt (data build tool)

Thank you so much for watching and supporting our channel. If you like what we're doing and want to see more, consider supporting us on Buy Me a Coffee. Your donations will go directly towards improving our content and keeping us motivated to bring you the best videos possible. Every coffee counts! ☕️

Thank you for being such an amazing community. We couldn't do this without you! 🎥✨

[nayeemsyed]

@Data Tech, by any chance can we get few scenario based interview questions on DBT cloud ?

[NarendraKumar-kbvs]

Thank you so much for your tutorials, this really helps me to start dbt.
Please share your email id to contact for training.

[tharunk]

Can you pls increase the video quality or resolution?

[amacodes]

Create video and thanks for this great content. I would like to highlight that when create the dataset in BQ choose multi region US if you would not overwrite the dbt project yaml file +location:, because you would face a hard time to run the models and could get the location not found in BigQuery

[anjaliacharya]

I do not have raw dataset in the dbt-training project I created, do we need to upload it or its created by default?

[MadhavCloud]

Nice video and was very helpful understand both dbt as well as bigquery along with Git integration but looks like missed something, I did not understand how the folder dbt_packages appeared in dbt and how raw folder was created and files uploaded.
any guidance is much appreciated.

[dennisdmak]

Weldon. I'm using dbt Oracle and this really helped

[GagandeepSingh-mqid]

I am missing the part where you setup the project in GCP, can you share the timeline ?

[shairy]

I am confident now after watching this tutorial. Looking now for more advance topics tutorials.

[dominicaleung]

thank you very much for your tutorial. very nice. Very good pace.

[kirankumar]

I was trying understanding dbt from various channels but finally I learned lot from your video which is boosting my career. Thanks bunch such wonderful and useful video.

[abdulghanishaik]

it was really good to start, but screen is not visible clearly.

[lakshmilfg]

Once dbt materializes all models as views, can I select a view directly in database and get the result I want? Because DAG will be defined within views ..right? Like View1--> View2--> View3..
Also if I dont have dbt in my company, Could I use nested views to recreate what dbt does?

[yashhooda]

can you please make a video on dbt core... if possible

[ugandarhari]

Thanks for such a nice content. Now I can add one more tool in my resume. Very informative session! The only flaw is the video quality, please try to upload HD resolution from next time, rest is awesome.

[junweizhang]

Best dbt tutorial for beginner u can find in Youtube! Well done dude!

[prashantchutke]

Do you have to create schema.yaml or it is created automatically? Is it updated on it's own when a new model is created or we have to update in manually?

[danieldumaraos]

Thank you so much! I have learned a lot just by watching this video. Now, I am confident tackling simple using dbt. What I hope to have seen on this video is the documentation and a little bit more about the model dependency lineage but overall the video is awesome!

[apatidar]

I'm trying to pass command dbt run but it keeps on failing the model I created, but if I preview the query it shows me table I am suppose to see. Can you help me out in what could be the issue? the other two example are running just fine.

[MikeChristopher-lm]

Do yourself a favor and just learn SQL and skip this little scripting tool.