Error installing dbt-spark on Windows 10

[dallyhorton]

I'm having trouble installing dbt-spark on Windows 10 Enterprise (version 1803). I have Python 3.7.6 and pip 20.1.1. I've attached the install log.

dbt-spark-install.log

[dallyhorton]

I've just got it working by:

• Using Chocolatey to install microsoft-visual-cpp-build-tools
• Manually pip installing the latest sasl wheel
• Creating a Python virtual environment
• Installing dbt-spark into this

Because I honestly have no idea what I'm doing, I'm not sure exactly which step fixed the issue. I did try the virtual environment trick before installing the build tools. I have the Visual Studio 2019 Build Tools on my machine, so perhaps I didn't install these property or they're newer than what the Chocolatey version installs. Anyway, in case other people have a similar issue, this is how I managed to fix it.

Interestingly, I also had the sasl error installing dbt-spark on my Mac before setting up a Python virtual environment.