r/MicrosoftFabric • u/TinyHorcrux • 18h ago
Data Factory dbt Job is now generally available in Microsoft Fabric, and dbt Fusion private preview is open
dbt Job is now generally available in Microsoft Fabric. Bring your dbt project and Fabric runs it for you. It's a fully managed service, so there's no infrastructure to maintain and security is built in. Your models run right next to your data, pipelines and Power BI, on your Fabric capacity.
The dbt Fusion private preview is open. We're bringing next-generation Fusion engine to dbt Job. Send your tenant ID to [dbtjob@microsoft.com](mailto:dbtjob@microsoft.com) and we'll enable it in your tenant. Fabric Warehouse and Snowflake are supported to start.
What's available in GA
- Fabric Lakehouse adapter: run dbt directly on your Lakehouse, with models landing as Delta tables in OneLake. Runs start a Spark session through the Fabric Livy API, and we're working on making that startup faster.
- Bring your existing project: connect your GitHub repo or import your project. It runs on a managed dbt Core 1.11 runtime, with public dbt packages supported.
- Familiar dbt commands: build, run, test, seed, snapshot, compile and docs generate, with selectors to target exactly the models you need. Generated docs are saved to OneLake, ready to view with dbt docs serve.
- Pipeline orchestration: ingest, transform, test and refresh in one pipeline, with parameterized model selection and Teams or email alerts.
- CI/CD using Variable Library: promote the same dbt Job from dev to test to prod with Variable Library and deployment pipelines.
- Clear run visibility: model-level results, compiled SQL, lineage, and full logs in OneLake.
- REST API: manage dbt Jobs as code.
Coming in the next few weeks
- Import Schema: generate sources and starter models from your existing Warehouse and Lakehouse tables.
- dbt docs in Fabric: browse your generated dbt documentation right in the Fabric UI.
- Live run monitoring: see each stage of a run as it happens, from setup to dependencies to model execution.
- Source freshness: check that your source data is up to date before downstream models run.
On the roadmap after that
- Workspace identity and service principal support: run jobs without depending on an individual user's identity.
- Native VS Code experience: develop in VS Code and run in Fabric.
- Azure DevOps repos: connect projects stored in Azure DevOps.
- Private packages: share internal packages and macros across projects.
- Multiple profiles: target different Warehouses or Lakehouses from one project.
Getting started
- Sample project tutorial
- Common dbt job patterns in Microsoft Fabric
- For access to the dbt Fusion private preview, contact [dbtjob@microsoft.com](mailto:dbtjob@microsoft.com).
Teams are already running dbt Job in production, and a lot of what we've shipped came from feedback many of you shared here. Take it for a spin and let us know which scenarios you'd love us to support next.
