How To Connect to Microsoft SQL Server In dbt (data build tool)

There is a misconception that you can only connect to a cloud database with dbt. In this tutorial, I will go through the instruction on how you can use dbt with a on premises Microsoft SQL Server database to streamline your SQL workflow.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#dbt #databuildtool #dbtlab #dataengineering #sqlserver

[FirstNameLastName-fveu]

I think he is an alien man !!! he does not even know something called IDE. An extremely smart and helpful Alien. I pay my respect to you.

[AlexDunnett-glpd]

Awesome intro. Great step-by-step guide. Got it working first time

[adityanjsg]

Saved me quite a money, thanks and superlike

[dragotzvetkov]

@Jie Jenn thanks for the video, very helpful! Do you know if this dbt SQL Server adapter supports cross-database references, meaning the source db is different than where the new table lands (within the same on-prem SQL Server instance).

[אלכסנחשונוב-פע]

Hi @Jie Jenn thanks for video, i tried to folly your instructions but i still get the certification error for some reason, any ideas what can i do next? :)

[mohammedvahid]

Hi bro how to get this terminal pls link bro.!!