Skip to main content

Microsoft Fabric DWH configurations

Materializations

Ephemeral materialization is not supported due to T-SQL not supporting nested CTEs. It may work in some cases when you're working with very simple ephemeral models.

Tables

Tables are default materialization.

models/example.sql
{{
config(
materialized='table'
)
}}

select *
from ...

Seeds

By default, dbt-fabric will attempt to insert seed files in batches of 400 rows. If this exceeds Microsoft Fabric Synapse Data Warehouse 2100 parameter limit, the adapter will automatically limit to the highest safe value possible.

To set a different default seed value, you can set the variable max_batch_size in your project configuration.

dbt_project.yml
vars:
max_batch_size: 200 # Any integer less than or equal to 2100 will do.

Snapshots

Columns in source tables can not have any constraints. If, for example, any column has a NOT NULL constraint, an error will be thrown.

Indexes

Indexes are not supported by Microsoft Fabric Synapse Data Warehouse. Any Indexes provided as a configuration is ignored by the adapter.

Grants with auto provisioning

Grants with auto provisioning is not supported by Microsoft Fabric Synapse Data Warehouse at this time.

Incremental

Fabric supports both delete+insert and append strategy.

If a unique key is not provided, it will default to the append strategy.

Permissions

The Microsoft Entra identity (user or service principal) must be a Fabric Workspace admin to work on the database level at this time. Fine grain access control will be incorporated in the future.

cross-database macros

Not supported at this time.

dbt-utils

Not supported at this time. However, dbt-fabric offers some utils macros. Please check out utils macros.

0