This release is a pre-release and may not be stable for production use.
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
Metadata
1 maintainer
Release files for dbt-fabric 1.11.2rc2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbt_fabric-1.11.2rc2.tar.gz | 195.0 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbt_fabric-1.11.2rc2-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 337.8 kB
Release files / dbt_fabric-1.11.2rc2.tar.gz
| Download URL | dbt_fabric-1.11.2rc2.tar.gz |
|---|---|
| Size | 195.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
66eef064c729cf3b9b134d8e3fc7938299abbb132d61b42bdce557028c0b3eae
|
|
BLAKE2b-256 checksum How to use checksums |
15f8647eb51c17a817cc2b9518be077d60fde3e3a7d0be200cbb91a6a82bfdaa
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.12.23 {"installer":{"name":"uv","version":"0.12.23","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}
|
Release files / dbt_fabric-1.11.2rc2-py3-none-any.whl
| Download URL | dbt_fabric-1.11.2rc2-py3-none-any.whl |
|---|---|
| Size | 142.8 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
9466eaa451232a0e0533af52ded3dc28fe47c9d75d1b3ce92fce14a9061b5199
|
|
BLAKE2b-256 checksum How to use checksums |
1b9e3a2c454fbb39ac635591c784c312fb4443ade641fa82eb663a0430ecfcdb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.12.23 {"installer":{"name":"uv","version":"0.12.23","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}
|
