install_dbt-sqlserver.ps1

# ensure python 3 is installed

cd ~
mkdir dbt-envs
cd dbt-envs
python -m venv dbt-env
.\dbt-env\Scripts\activate

# install dbt-core
git clone https://github.com/dbt-labs/dbt-core.git
cd dbt-core
pip install -r .\requirements.txt
dbt --version
cd ..

# install dbt-sqlserver
git clone https://github.com/dbt-msft/dbt-sqlserver.git
cd dbt-sqlserver
pip install .

# create new dbt project
# cd ~
# mkdir dbt-sql-test
# cd dbt-sql-test
# dbt init sql-test