Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This feature is in preview.
dbt job in Fabric brings the power of dbt (Data Build Tool) directly into the Fabric experience. You can transform data with SQL in a familiar, unified environment. Build, test, and deploy dbt models on top of your Fabric data warehouse or other supported warehouses—no need to install local tools or manage external orchestration.
You can develop and manage transformation logic entirely within Fabric. Author your models, define dependencies, and run tests in one place while you use Fabric's enterprise-grade security and governance.
Fabric integrates with dbt Core to provide:
- No-code setup for onboarding and configuration
- Native scheduling and monitoring to keep workflows reliable and transparent
- Visual insights into dbt runs, tests, and lineage—all within the same workspace as your pipelines and reports
This approach combines the flexibility of code-first development with the simplicity of low-code orchestration so analytics and engineering teams can collaborate and scale transformations across the organization.
How to enable dbt jobs preview
Go to the admin portal in Fabric.
Under Tenant settings, enable the dbt jobs (preview) feature for your organization or specific security groups.
Required permissions and access
- In your Fabric workspace, you need a Contributor role or higher to create or manage dbt jobs.
- For the target Fabric Data Warehouse, you need read/write permissions to run dbt transformations.
- You need both build and read/write access to linked datasets and connections.
Supported adapters and runtime
You can connect a dbt job to multiple data sources by using supported adapters. An adapter is a connector that allows dbt to work with a specific data platform by handling connections, running SQL transformations, and managing platform-specific behavior.
In Fabric, a dbt job runtime is a managed execution environment that provides a consistent and secure way to run dbt jobs. It simplifies execution by offering a versioned environment that includes dbt capabilities, ensuring reliability and performance across workloads. Currently, when you create a dbt job, it uses dbt job runtime V1.0 by default.
The following table shows the adapters supported in dbt jobs, along with the runtime and adapter versions available in the managed execution environment.
| Adapter | dbt job runtime version | Adapter version | Supported dbt version | Python version |
|---|---|---|---|---|
| Azure SQL Database | V1.0 | 1.8.5 | dbt Core 1.9 | 3.12 |
| Fabric Data Warehouse | V1.0 | 1.9.0 | dbt Core 1.9 | 3.12 |
| PostgreSQL database | V1.0 | 1.9.0 | dbt Core 1.9 | 3.12 |
| Snowflake | V1.0 | 1.9.0 | dbt Core 1.9 | 3.12 |
Note
This matrix reflects versions available in the Fabric-managed dbt job runtime.
V1.0 is the latest dbt job runtime version in Fabric.
Adapter versions and dbt versions are updated regularly to include new features, performance improvements, and platform compatibility updates. For adapter configuration and setup, refer to Configure a dbt job.
Limitations
- No build caching: Currently, preview only supports compiling and executing a project fresh from the source. dbt artifacts produced from previous runs aren't available for recompilation.
- Adapter constraints: Some partner adapters aren't yet supported in Fabric. See the current supported adapters.