I’m evaluating dbt for adoption at my enterprise. We currently use SQL Server but plan to migrate off of it. I want to introduce dbt before the backend transition to help with change management. Unfortunately I cannot figure out the degree to which SQL Server is currently supported.
There’s a community plugin for SQL Server discussed in the dbt docs and available on Github that says it supports “dbt-core 1.10 or newer” but the dbt Core v2 / fusion change seems to have disrupted that. There’ a Support Custom Adapters issue that appears stalled, so it seems community adapters are going away entirely. The Trusted Adapter page doesn’t list SQL Server at all and only a small subset of the trusted adapters have Fusion support.
So my question is: what is the plan for SQL Server support in dbt Core v2? Is dbt moving to a proprietary connectors only?
If those are all blocking, then what’s the support window for DBTcore v1, which has the connectivity I need?