dbt-fabric
dbt adapter for Microsoft Fabric Synapse Data Warehouse.
The adapter supports dbt-core 1.4 or newer and follows the same versioning scheme. E.g. version 1.1.x of the adapter will be compatible with dbt-core 1.1.x.
Documentation
We've bundled all documentation on the dbt docs site
Installation
This adapter uses mssql-python to connect to Fabric, which bundles its own driver.
Latest version:
pip install -U dbt-fabric
Performance guidance for large projects
Fabric Warehouse DDL operations (e.g. CREATE TABLE, sp_rename) hold catalog locks that can block sys.tables/sys.views reads from concurrent dbt sessions. With many models and high thread counts this causes list_<schema> steps to stall for minutes.
Strongly recommended for projects with 500+ models or concurrent dbt runs:
# profiles.yml
my_fabric_project:
target: dev
outputs:
dev:
type: fabric
# ... connection settings ...
threads: 4 # keep low (4–8) to reduce catalog lock pressure
query_timeout: 30 # fail fast on blocked catalog reads (seconds)
In your dbt_project.yml:
flags:
cache_selected_only: true # only list schemas for models in the current run
Or pass --no-populate-cache on the CLI for a single run. This prevents dbt from listing every schema in the warehouse upfront, significantly reducing catalog read pressure during concurrent runs.
Changelog
See the changelog
Contributing
This adapter is Microsoft-maintained. You are welcome to contribute by creating issues, opening or reviewing pull requests. If you're unsure how to get started, check out our contributing guide.
License
Code of Conduct
This project and everyone involved is expected to follow the Microsoft Code of Conduct.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file dbt_fabric-1.11.1.tar.gz.
File metadata
- Download URL: dbt_fabric-1.11.1.tar.gz
- Upload date:
- Size: 145.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
uv/0.12.5 {"installer":{"name":"uv","version":"0.12.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
6927abb6c71950fc7decb6f5b02afd06bc2b395eb13c87b0891c1a5ac90a2846
|
|
| MD5 |
774209e89ac2341c90615212374f34e7
|
|
| BLAKE2b-256 |
ec9e940744ae2555e835d29ea14c8edcc052ec11d90827b1bec8830384039c1d
|
File details
Details for the file dbt_fabric-1.11.1-py3-none-any.whl.
File metadata
- Download URL: dbt_fabric-1.11.1-py3-none-any.whl
- Upload date:
- Size: 126.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
uv/0.12.5 {"installer":{"name":"uv","version":"0.12.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
f82e349d582ac52e12a0b7a197b6fb379627f4bc2f775388355e737901df2f89
|
|
| MD5 |
3b450e48e2f83214bc508554f25d602f
|
|
| BLAKE2b-256 |
6a975b1e6edd560cec4d7d128b69f79647a2835bb75c398ae08a616a6855e417
|
