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

[@kirankumar1290]

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.

[@DataTechByAnandKumar]

Thank you! Could you please share the video among your colleagues or organization? It would be help us

[@kirankumar1290]

@@DataTechByAnandKumar sure I will share the video in my organization. can you publish one more video on dbt with airflow

[@toddai2721]

Because of your tutorial, my wife finally will have relations.

[@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!

[@DataTechByAnandKumar]

Thanks for the feedback Daniel!! I will try to make video on documentation and model dependency lineage

[@shairy79]

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

[@zoro-nw6jx]

thanks best video learned a lot

[@junweizhang1034]

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

[@amacodes7347]

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

[@dennisdmak]

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

[@OPopoola]

Thanks. The best intro to dbt yet.

[@KomalVashishth-th3fw]

great video.. wonderful explanation and crisp to knowledge. Thank you.

[@dominicaleung7329]

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

[@nayeemsyed3033]

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

[@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.

[@DataTechByAnandKumar]

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! ☕️ 👉 Support us here: buymeacoffee.com/datatechdeq Thank you for being such an amazing community. We couldn't do this without you! 🎥✨

[@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.

[@yashhooda4441]

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

[@ankushgupta2292]

Very well explained..

[@RahulDhanawade-im7su]

very helpful! Thanks mate.

[@GagandeepSingh-mq1id]

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

[@abdulghanishaik]

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

[@preetybaderiya7268]

its awesome for bignners

[@junpei0berkeley]

well done!

[@tharunk8019]

Can you pls increase the video quality or resolution?

[@anjaliacharya9506]

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

[@DataTechByAnandKumar]

You must upload datasets, but there are also example datasets provided.

[@aleksandrshipilo4467]

Thank you for the tutorial)

[@bhavesh6806]

Nicely explained

[@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?

[@DataTechByAnandKumar]

In order to create dynamic yml , my guess is that you could use codegen and especially the generate_model_yaml. hub.getdbt.com/dbt-labs/codegen/latest/ So you would have to execute : dbt run-operation generate_model_yaml --args '{"model_names": ["orders"]}' then if you want the file .yml to be automatically created with the "description" key filled with the name preceding it, you can use www.dbt-power-user.com/

[@lakshmilfg1147]

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?

[@DataTechByAnandKumar]

We have the option to construct views upon existing views, but I wouldn't advise it because of potential performance issues.

[@apatidar32]

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.

[@apatidar32]

it got resolved, apparently it's a location issue. My dataset was not multi-region so have to relocate it. Could make a small video on how to configure dataset location to auto detect in dbt itself, in profile.yml file

[@youssefassoud3767]

@@apatidar32 How do you solved this issue please ?

[@Aman-lv2ee]

is dbt an alternative of spark?

[@DataTechByAnandKumar]

Not really, it depend on the use case.

[@cheedellasrinivas8090]

Video is nice, could you please explain advance concepts of dbt like dbtmesh and semantic layer

[@abdulazizmamun]

Great Video Anand. Time to make hand dirty

[@MikeChristopher-l6m]

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

[@MinerCold-w1s]

shut up

[@Ahmed-lt6rr]

Do you have any platform or discord ?

[@NarendraKumar-kb1vs]

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