Installation

Prerequisites

Python

Make sure you have Python 3.10 or higher installed. You can check your Python version by running:

python --version

ODBC Driver

This adapter requires the ODBC Driver for SQL Server.

WindowsmacOSLinux

Download and install the ODBC Driver from Microsoft Learn.

1. Install Homebrew if you haven't already:

   /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
   

2. Add the MS ODBC Driver tap:

   brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
   

3. Update Homebrew:

   brew update
   

4. Install the ODBC Driver (this has a dependency on unixodbc which will be installed automatically):

   brew install msodbcsql18
   

Follow the instructions on Microsoft Learn to install the ODBC Driver and its dependencies for your specific Linux distribution.

Install dbt-fabric-samdebruyn

Install dbt-fabric-samdebruyn using pip:

pip install dbt-fabric-samdebruyn dbt-core