---
id: dbt-fabric
version: "1.11.0"
license: MIT
license_treatment: permissive
maintenance: active
---

# dbt-fabric — A Microsoft Fabric Synapse Data Warehouse adapter plugin for dbt

License: permissive · Maintenance: active · Downloads: 2.2M/mo

## What it is and what it does

dbt-fabric is a plugin that extends dbt-core to work with Microsoft Fabric Synapse Data Warehouse. It handles the translation of dbt's SQL and YAML models into Fabric-native DDL and DML operations, using the mssql-python driver to connect and execute transformations. The adapter follows dbt-core's versioning scheme, so version 1.11.0 is compatible with dbt-core 1.11.x.

The adapter is designed for data teams building transformation pipelines on Fabric. It supports standard dbt workflows—model definition, testing, documentation, and lineage tracking—while managing Fabric-specific concerns like catalog locks on DDL operations. For large projects (500+ models) or concurrent dbt runs, the documentation recommends keeping thread counts low (4–8) and setting query timeouts to avoid catalog lock contention that can stall metadata reads.

Use it for:

- Build and version-control SQL transformation pipelines in Fabric Synapse Data Warehouse using dbt's standard project structure.
- Run dbt tests and generate documentation for Fabric-based data models alongside your warehouse schema.
- Orchestrate concurrent dbt runs on Fabric with tuned thread counts and timeouts to avoid catalog lock blocking.
- Migrate existing dbt projects from other data warehouses to Fabric by switching the adapter and updating connection profiles.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

A dbt adapter that connects dbt-core to Microsoft Fabric Synapse Data Warehouse, enabling data transformation and modeling workflows on Fabric.

Yes, if you use dbt-core and need to deploy transformations to Microsoft Fabric Synapse Data Warehouse. The adapter is actively maintained, has low install friction, carries no known vulnerabilities, and is MIT-licensed. Install only if you have a Fabric warehouse and dbt-core 1.4 or newer; it is not useful as a standalone tool.

## Install

pip install dbt-fabric
uv add dbt-fabric
poetry add dbt-fabric

## Installing dbt-fabric

Before you install: Low friction install. Actively maintained with a release 5 days ago. Requires dbt-core 1.4 or newer and follows matching version schemes (1.11.0 adapter pairs with dbt-core 1.11.x). Bundles mssql-python driver for Fabric connectivity.

License in practice: MIT license (permissive). No restrictions on commercial use, modification, or redistribution as long as the license notice is retained.

Quickstart:

pip install -U dbt-fabric

# In profiles.yml:
my_fabric_project:
  target: dev
  outputs:
    dev:
      type: fabric
      threads: 4
      query_timeout: 30

Requires dbt-core 1.4 or newer; Python 3.12–3.13. For projects with 500+ models or concurrent runs, low thread counts (4–8) and query_timeout settings are strongly recommended to avoid catalog lock contention.

Verify before relying:

- Whether mssql-python driver installation requires additional system dependencies or configuration beyond pip install.
- Specific authentication methods supported (service principal, managed identity, user credentials) beyond generic Azure authentication.
- Performance characteristics and scalability limits for typical Fabric warehouse sizes.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 2.2M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dbt adapter microsoft fabric, dbt synapse data warehouse, fabric synapse dbt plugin, dbt-core fabric connector, microsoft fabric dbt integration, dbt fabric adapter, synapse warehouse dbt, dbt-adapter, data-warehouse, etl-elt

[View on SkillFed](https://skillfed.io/packages/dbt-fabric) · [View on PyPI](https://pypi.org/project/dbt-fabric/)