dbt-fabric
A Microsoft Fabric Synapse Data Warehouse adapter plugin for dbt
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- Low friction install.
License · maintenance · safety
MIT (permissive) — MIT license (permissive). No restrictions on commercial use, modification, or redistribution as long as the license notice is retained.
last release 2026-08-09 (5 days) · last repo commit 2026-08-10 · 145 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 2,173,832 downloads/mo, #3,232 on PyPI
Alternatives
Verify before relying
pip install -U dbt-fabric
# In profiles.yml:
my_fabric_project:
target: dev
outputs:
dev:
type: fabric
threads: 4
query_timeout: 30- 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.
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 on it.
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
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.
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.
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: 30Verify 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 the current Python release <3.14,>=3.12 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 7 packagesazure-coreazure-identitydbt-adaptersdbt-commondbt-coremssql-pythonrequests |
| Maintenance | Actively maintained 5 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 2,173,832 / month, #3,232 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableLicense :: OSI Approved :: MIT LicenseOperating System :: MacOS :: MacOS XOperating System :: Microsoft :: WindowsOperating System :: POSIX :: LinuxProgramming Language :: Python :: 3.12Programming Language :: Python :: 3.13 |
Evidence: dbt_fabric-1.11.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “dbt adapter microsoft fabric”
- dbt-fabricA dbt adapter that connects dbt-core to Microsoft Fabric Synapse Data…
- dbt-fabricsparkA dbt adapter that connects dbt to Apache Spark in Microsoft Fabric…
- dbt-sqlserverA dbt adapter that enables data transformation and testing workflows…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also dbt-fabricspark · dbt-loom · dbt-sqlserver · dbt-vertica · dbt-snowflake · dbt-core · dbt-clickhouse · dbt-exasol · dbt-bigquery · dbt-metricflow