Problems installing Fabric and Snowflake adapters

Help
1

Hello,

I’ve been trying to install dbt fabric adapter following the guidelines here: Microsoft Fabric Synapse Data Warehouse setup | dbt Developer Hub

But the installation fails each time with the following errors:

Building wheels for collected packages: pyodbc
Building wheel for pyodbc (pyproject.toml) … error
error: subprocess-exited-with-error

× Building wheel for pyodbc (pyproject.toml) did not run successfully.
│ exit code: 1
╰─> [108 lines of output]
WARNING: ‘’ not a valid package name; please use only .-separated package names in setup.py
running bdist_wheel

  error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2022\\BuildTools\\VC\\Tools\\MSVC\\14.42.34433\\bin\\HostX86\\x64\\cl.exe' failed with exit code 2
  [end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
ERROR: Failed building wheel for pyodbc
Failed to build pyodbc
ERROR: Failed to build installable wheels for some pyproject.toml based projects (pyodbc)

I have installed dbt core in virtual environment and the virtual environment is activated before running the command for installing dbt fabric adapter. First time I tried to install the adapter I didn’t have the Build Tools for Visual Studio 2022 installed and the installation failed. Then I installed the Build Tools but it didn’t really help.

I’ve tried editing the path for Build Tools (MSVC) in system variables as it originally had Hostx64 and the path in the error message has Hostx86. But this doesn’t seem to have any effect either.

Any idea what could be wrong? I have asked the same question in Fabric Partner Community as well. But after that I tried installing Snowflake adapter and got the same error so the problem is not specific to Fabric.
I see that others have had also issues with adapter installations: pip install dbt-snowflake (ERROR: Failed building wheel for snowflake-connector-python (WINDOWS))
But the error message was different there and the problem wasn’t solved either.

2

This was an incompatibility issue between the adapter and Python version. I had the latest official release of Python version 3.13. I installed version 3.11 and was able to install all the dbt adapters I wanted to install (fabric, Snowflake, Synapse, Databricks), so problem solved.