Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

pvenkat3
‎03-24-2026 01:00 PM

dbt+ Microsoft Fabric: A strategic investment in the modern analytics stack

If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings. 

Co-Author: Abhishek Narain

Why dbt + Microsoft Fabric matters

Modern analytics teams are adopting open, SQL-first data transformation, robust CI/CD and governance, and seamless integration across lakehouse and warehouse platforms. dbt is now the standard for analytics engineering, while Microsoft Fabric unifies data engineering, science, warehousing, and BI in OneLake.

By investing in dbt + Microsoft Fabric integration, Microsoft empowers customers with a unified, enterprise-grade analytics platform that supports native dbt workflows—future-proofing analytics engineering on Fabric.

Diagram_illustrating_dbt_as_a_standard_for_SQL_data_transformation_showing_a_worDiagram_illustrating_dbt_as_a_standard_for_SQL_data_transformation_showing_a_wor

Figure 1: dbt-sql-transformations.

Adapter investments across the analytics surface area

A core part of this strategy is adapter depth, not just adapter availability. In the analytics space, adapters are more than connectivity layers—they define:
  • Performance characteristics.
  • Supported SQL semantics.
  • Materialization behavior.
Microsoft is investing in first-class dbt core adapters aligned with Fabric workloads:
  • Fabric Warehouse dbt core adapter – enabling SQL-first analytics engineering on enterprise warehouses
  • Coming soon: Fabric Lakehouse dbt core adapter (Generally Available)– unlocking analytics engineering directly on lakehouse tables in OneLake
These adapters are designed to respect Fabric-native concepts such as:
  • OneLake storage abstraction.
  • Separation of compute and storage.
  • Enterprise governance and security.

Build and operationalize with dbt Jobs on Microsoft Fabric

For customers running dbt at scale, dbt Jobs is the operational backbone—handling scheduling, retries, observability, and environment promotion.

We opened the public preview for dbt Jobs in December 2025, and based on your feedback, we’re announcing a set of richer, enterprise‑ready features that further strengthen dbt Jobs as the production control plane for analytics on Microsoft Fabric.

What’s new with dbt Jobs

  • Public package support: dbt Jobs now supports public and community packages, helping teams accelerate development by reusing proven transformations and standardizing analytics patterns across the organization.
  • Native GitHub support: Teams can now run dbt Jobs directly from dbt code stored in GitHub, enabling tighter CI/CD integration and aligning analytics workflows with standard software engineering practices.
  • Enterprise‑scale logging to OneLake: dbt Jobs can stream execution logs directly to OneLake with no size limits, removing the previous 1 MB output log cap. This enables full‑fidelity troubleshooting, auditing, and long‑term observability using Fabric‑native analytics tools.
  • Pipeline dbt activity support (coming soon): dbt Jobs will be available as a native activity in Fabric pipelines with parameterization support, allowing teams to orchestrate dbt workloads alongside other data and AI processes—while keeping dbt as the execution and governance engine.
  • API support for dbt job: Provides programmatic APIs to trigger, monitor, and manage dbt job executions, enabling CI/CD integration, external orchestration, and enterprise-grade automation of analytics workflows.
  • Lakehouse adaptor support (coming soon): dbt jobs currently support many adaptors, including Fabric DW, and will soon add LH adaptor support.
Our integration with dbt Jobs ensures that:
  • Fabric warehouses and Lakehouse's can participate naturally in dbt Jobs workflows.
  • Teams can standardize on dbt Jobs for orchestration while leveraging warehouse and lakehouse for compute and storage.
This is especially important for customers standardizing on dbt Jobs as their control plane while adopting warehouse or lakehouse as their analytics platform.

What’s ahead: dbt Fusion and Microsoft Fabric

Diagram_illustrating_upcoming_integration_between_Microsoft_Fabric_and_dbt_LabsDiagram_illustrating_upcoming_integration_between_Microsoft_Fabric_and_dbt_Labs

Figure 2: dbt-Microsoft Fabric.

Microsoft is actively working to support dbt Fusion as part of our continued investment in dbt on Fabric. Based on current plans, dbt Fusion support is expected to be available later in Q2 of calendar year 2026.

This work includes:

  • Warehouse and Lakehouse adapters that integrate cleanly with dbt Fusion.
  • Ensuring Fabric workloads can participate fully in Fusion‑powered dbt Jobs.
  • Aligning execution, metadata, and observability between Microsoft Fabric and dbt’s next‑generation architecture.
These efforts build directly on the dbt Jobs and adapter investments already in motion—helping ensure customers can adopt dbt Fusion when it becomes available without rework or disruption to their existing Fabric analytics platform.

FabCon: Where dbt and Fabric come together

If you want to see this strategy come to life, FabCon is the place to be. Microsoft and dbt are using FabCon to share:
  • The current state of dbt + Fabric integration.
  • Real-world patterns for warehouses and lakehouses.
  • Forward-looking direction around dbt Fusion.
Please be aware of upcoming FabCon announcements regarding dbt and Microsoft Fabric. This area is currently experiencing significant innovation and progress.

Resources

0