dbt-core-sqlserver

• A repo for building dbt-core + dbt-sqlserver.

• Based on Debian 12, from python container image. Check Containerfile for specific python version.

What is included?

Packages from python-pip

dbt-sqlservern

Debian packages from apt:

msodbcsql18 
unixodbc-dev
gnupg2
curl
netcat-traditional
telnet
nano
vim

How can I use this?

Jumping in and out from containers can be a bit confusing, interfacing with paths and stuff. To make it easier, this repo contains a dbt.sh script to make it feel like you are running it locally.

• dbt.sh and the container is designed to run without sudo.
• You need to have either podman or docker installed.

How to install the script

Download the dbt.sh,rename it to dbt and put it in your PATH, then make it executable. Here is a oneliner to download it, make it executable and put it in ~/.local/bin/dbt.

wget -O ~/.local/bin/dbt https://codeberg.org/fyksen/dbt-core-sqlserver/raw/branch/main/dbt.sh && chmod +x ~/.local/bin/dbt

First time run

Create a dbt directory:

mkdir dbt
cd dbt

Run dbt init to initialize

dbt init

Change the connection details in .dbt/profiles.yml. The script automatically created a template you can use. so you do not have to figure out the driver.

Script info:

Want more details about the script? Have a look at the dbt.sh-README.md file.

Video guide:

asciicast