Install dbt in a virtual environment // best practice

When installing dbt CLI on your local machine, specifically on Windows, it can at times be a little tricky. A best practice is to install dbt into a virtual environment so that you can have clear control over the dependencies and versions of everything interacting with your project.

In this video, we will not only walk through the process of installing dbt into a virtual environment on windows, but also look at how to install dbt directly from dbt core (github) rather than by using pip.

Timestamps:
0:00 - Intro
0:21 - Create Virtual Environment
0:59 - Activate Virtual Environment
1:25 - Install DBT From DBT Core
2:50 - Initialize a DBT Project
3:29 - Recap

Title & Tags:
Install DBT in Virtual Environments | Create dbt Project | dbt labs | Data Build Tool (dbt) Tutorial
#kahandatasolutions #dataengineering #databuildtool
#dbtdata #clouddatabase #snowflakedatawarehouse

[vijayadurga]

I have installed pip and them DBT in cmd . How can i further proceed to create models? Do i need to install any code editor? If so how to install it and connect with DBT that is already created

[rahulkrishkampati]

How do I reopen the virtual environment after closing?

[himanshuranjan]

Can we use dbt to build stored procedures?

[krisgarcia]

What happened to the git dbt folder when you initialized at the end? Did you delete it or does it automatically get deleted when initializing dbt?

[sotirigeorgiou]

Also, for mac os users is installing through brew a good option?

[sotirigeorgiou]

Out of curiosity, what dependency issues did you run into when install dbt from pypi?

[tlubaina]

After pulling my hair for 2 nights, this video is a saviour if you want to avoid the hassle to go through weird dependency failures, version mismatch or just windows being windows 🤷‍♀
Thanks!

[davidpui]

Hi Kahan Followed your steps but somehow dbt-env cannot be activated. It looks like its activated but it's not even though the prompt came up but not in green colour and also when i issue dbt --version no response

[grantdoyle]

in the first step of trying to create the python environment, I get the error: Python was not found, run without arguments to install from Microsoft store