tconbeer/install_dbt_from_scratch_on_windows.txt

## install_dbt_from_scratch_on_windows.txt
# Any lines preceded by > can be typed or pasted directly into Powershell.
# This has been tested on Windows 10 and dbt v 0.12. Last updated Jan 4, 2019

# Before trying to follow this recipe, you need to set the Execution Policy
# You probably need to do this running Powershell as an admin
> Set-ExecutionPolicy RemoteSigned

# Next install chocolatey:
> iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

# Use Chocolatey to install python and git
> choco install python -y
> choco install git -y

# Optionally, use Chocolatey to install other useful apps
> choco install github-desktop -y
> choco install atom -y
> choco install datagrip -y

# You need to refresh your environment variables to add Python to your PATH.
# Do that by exiting Powershell or running:
> refreshenv

# At this point, you can/should continue using Powershell as your user, not an
# Administrator. Use pip to install pipenv for a virtual environment, but
# update pip first
> python -m pip install --upgrade pip
> pip install pipenv

# So far, we've just been installing python and other generally-useful modules
# Now we start installing dbt specifically. To prevent conflicts with other
# python packages, and to stay in sync across machines, we do this inside of a
# virtual environment, using pipenv

# Navigate to the directory that you want to contain your dbt projects.
> mkdir dbt
> cd dbt

##### IF USING AN EXISTING DBT PROJECT #####
# First clone the repository (assumes you're using git and Github)
# If this is a private repo, you'll have to authenticate git somehow
# (Github Desktop can do this for you)
> git clone https://github.com/my-org/my-dbt-project.git

# Install dbt from the Pipfile (assumes other contributors are using Pipenv)
> cd .\my-dbt-project\
> pipenv install

# Run dbt inside of pipenv by first running pipenv shell. Run dbt Help to
# confirm installation
> pipenv shell
>> dbt --help

##### IF CREATING A NEW DBT PROJECT #####
# In the master directory, install dbt using pipenv
> pipenv install dbt

# Run dbt inside of pipenv by first running pipenv shell. Run Help to confirm
# installation
> pipenv shell
>> dbt --help

# Create a new dbt project
>> dbt init my-dbt-project

# You will need to edit the profile in the .dbt directory that gets created elsewhere
# in order to connect to your database and run dbt. See
https://docs.getdbt.com/docs/configure-your-profile
	# Any lines preceded by > can be typed or pasted directly into Powershell.
	# This has been tested on Windows 10 and dbt v 0.12. Last updated Jan 4, 2019

	# Before trying to follow this recipe, you need to set the Execution Policy
	# You probably need to do this running Powershell as an admin
	> Set-ExecutionPolicy RemoteSigned

	# Next install chocolatey:
	> iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

	# Use Chocolatey to install python and git
	> choco install python -y
	> choco install git -y

	# Optionally, use Chocolatey to install other useful apps
	> choco install github-desktop -y
	> choco install atom -y
	> choco install datagrip -y

	# You need to refresh your environment variables to add Python to your PATH.
	# Do that by exiting Powershell or running:
	> refreshenv

	# At this point, you can/should continue using Powershell as your user, not an
	# Administrator. Use pip to install pipenv for a virtual environment, but
	# update pip first
	> python -m pip install --upgrade pip
	> pip install pipenv

	# So far, we've just been installing python and other generally-useful modules
	# Now we start installing dbt specifically. To prevent conflicts with other
	# python packages, and to stay in sync across machines, we do this inside of a
	# virtual environment, using pipenv

	# Navigate to the directory that you want to contain your dbt projects.
	> mkdir dbt
	> cd dbt

	##### IF USING AN EXISTING DBT PROJECT #####
	# First clone the repository (assumes you're using git and Github)
	# If this is a private repo, you'll have to authenticate git somehow
	# (Github Desktop can do this for you)
	> git clone https://github.com/my-org/my-dbt-project.git

	# Install dbt from the Pipfile (assumes other contributors are using Pipenv)
	> cd .\my-dbt-project\
	> pipenv install

	# Run dbt inside of pipenv by first running pipenv shell. Run dbt Help to
	# confirm installation
	> pipenv shell
	>> dbt --help

	##### IF CREATING A NEW DBT PROJECT #####
	# In the master directory, install dbt using pipenv
	> pipenv install dbt

	# Run dbt inside of pipenv by first running pipenv shell. Run Help to confirm
	# installation
	> pipenv shell
	>> dbt --help

	# Create a new dbt project
	>> dbt init my-dbt-project

	# You will need to edit the profile in the .dbt directory that gets created elsewhere
	# in order to connect to your database and run dbt. See
	https://docs.getdbt.com/docs/configure-your-profile