dbt-fabric

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 on this page — 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

dbt-fabric on PyPI

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

Evidence: dbt_fabric-1.11.0-py3-none-any.whl

Tags

More Front-Ends packages