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!
-------------------------------------------------------------------------------------------
☕ Paypal: www.paypal.me/...
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩‍💻 Follow me on Linked: / jiejenn
🌳 Becoming a Patreon supporter: / jiejenn
✉️ Business Inquiring: [e-mail]
#dbt #databuildtool #dbtlab #dataengineering #sqlserver

[@FirstNameLastName-fv4eu]

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-gl4pd]

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

[@jiejenn]

Glad you found the video useful.

[@adityanjsg99]

Saved me quite a money, thanks and superlike

[@jiejenn]

Glad you found the video helpful!

[@user-nf7ww2et4m]

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? :)

[@dragotzvetkov7157]

@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).

[@jiejenn]

I don't think dbt is capable of doing that as of now, but if you want to reference to other database in your SQL query, you can simple append the database name in the table source. For example [database name].[schema].[table name]

[@mohammedvahid5099]

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

[@jiejenn]

I'm using Git terminal.

[@mohammedvahid5099]

@@jiejenn how it using pleas make an video bro and how to setup using with DBT and with snowflake integrations