dbt Job in Microsoft Fabric: Ship Trustworthy SQL Models Faster (Preview)
We’re excited to introduce dbt Jobs in Microsoft Fabric—a capability that lets existing dbt users seamlessly integrate their trusted workflows into Fabric’s Data Factory experience. With this integration, data engineers and analysts can author, orchestrate, and operationalize dbt-based transformations natively within Fabric, combining the modular, version-controlled, and testable approach you already know with enterprise-grade governance, CI/CD, and monitoring. By unifying code-first flexibility with low-code options, Fabric empowers analytics and engineering teams to collaborate effortlessly and scale transformations across the organization—all within a secure, governed, and familiar environment.
We’re also thrilled to announce a close collaboration between dbt Labs and Microsoft Fabric. As part of this collaboration, we’re working to bring dbt Fusion into Microsoft Fabric, delivering next-generation performance and advanced developer capabilities. This will become available in calendar year 2026.
Why dbt and Why It Matters
dbt has become the industry standard for SQL-based data transformation, trusted by thousands of organizations worldwide. Here’s why:
- SQL-Native Approach: dbt empowers analytics engineers to transform data using SQL—the language they already know—without needing complex ETL tools or proprietary scripting.
- Version Control & Testing: Built-in testing and documentation ensure data quality and transparency, reducing risk and improving trust in analytics.
- Scalable Collaboration: dbt promotes modular, reusable models, enabling teams to collaborate effectively across large-scale projects.
By bringing dbt natively into Microsoft Fabric, we eliminate friction:
- No CLI Setup or Local Dependencies: Everything runs in a serverless, managed runtime—no jump-outs, no extra tooling.
- Unified Experience: Author, schedule, and monitor dbt jobs alongside other Fabric activities in one place.
- Enterprise-Grade Security: Leverage Entra ID authentication, workspace roles, and SQL RLS/CLS/OLS policies so transformations inherit governance by default.
Key Capabilities
- Native Authoring: Create and manage dbt projects directly in Fabric Data Factory.
- Integrated Testing & Documentation: Validate models and maintain documentation without leaving Fabric.
- Operationalization: Automate runs with built-in scheduling and monitoring.
- Performance & Reliability: Powered by Fabric’s distributed architecture for robust execution.
- Governance by Design: Enterprise security controls applied automatically to every transformation.
Getting Started
The tenant admin dbt job preview enablement UI will roll out to all regions in the coming weeks (December 2025).
Update (December 21, 2025): The rollout is complete, and dbt jobs can now be enabled in your tenant via the Fabric Admin portal.
Fabric Tenant Admins can enable dbt Jobs via the Fabric Tenant Admin Portal:
- Navigate to Settings → Admin Portal.
- Under Tenant Settings, expand Users can create dbt job items.
- Toggle to Enabled and apply to your organization.
After enabling the dbt job preview, you can create dbt jobs in your workspaces.
