v1.12.0

Highlights

• dbt Core 1.12 support (compatibility)
• FabricSpark (Lakehouse) adapter matured significantly — now a first-class adapter alongside Fabric DW (lakehouse guide)
• Microsoft Purview integration for syncing dbt metadata to your data catalog (docs)
• dbt-external-tables support via OPENROWSET (docs)
• Documentation site rebuilt on Zensical with extensive new content (dbt-fabric.debruyn.dev)

FabricSpark (Lakehouse) adapter

See the Lakehouse guide and FabricSpark configuration.

• New materializations: incremental, snapshot, clone, materialized_view (lake views), and proper view support
• Default materialization changed to view (matches dbt-spark conventions)
• Cross-workspace 4-part naming
• persist_docs support
• High-concurrency Livy sessions for parallel statement execution
• Configurable Fabric API base URLs for non-production tenants (gov clouds, sovereign clouds)
• Fixed source freshness failures on Lakehouse (ported from upstream)
• Fixed snapshots failing with character varying type error
• Fixed TestMetadataWithEmptyFlag parse-time crash
• Fixed escape_single_quotes behavior
• Fixed schema filter push-down in list_relations_without_caching (performance)
• Handle [SCHEMA_NOT_FOUND] gracefully in relation listing
• Force JVM GC after synapsesql writes to release JDBC schema locks

Fabric Data Warehouse

• Snapshots now use a single MERGE statement instead of UPDATE + INSERT (atomic, simpler) — see warehouse snapshots
• apply_label() decoupled from statement termination
• CLUSTER BY support on tables — see cluster by
• New statistics config option — see statistics
• Approximate row count statistics in catalog generation — see catalog stats
• Fixed T-SQL identifier quoting to use brackets ([ ])
• Fixed rows_affected reporting -1 for table materializations
• Automatic retry for transient snapshot isolation errors on metadata queries
• Singleton pollution fix in TestWarehouseSnapshots

Authentication

See the authentication guide for the full walkthrough.

• New workload_identity method for federated credentials (CI/CD-friendly, OIDC)
• New token_credential method (ported from upstream)
• Authentication doc significantly expanded with end-to-end setup walkthroughs

Community package compatibility

Integration tests and macro overrides added for both Fabric and FabricSpark across these packages — see the packages index for required dispatch config and per-package notes:

• dbt-utils
• dbt-date
• dbt-expectations
• dbt-audit-helper
• dbt-codegen
• dbt-profiler
• dbt-external-tables
• dbt-project-evaluator — Lakehouse only; Fabric DW support pending upstream dbt-labs/dbt-project-evaluator#576
• dbt_artifacts — Lakehouse only; Fabric DW (and Synapse) support pending upstream brooklyn-data/dbt_artifacts#529

Documentation

Docs site migrated from mkdocs-material to Zensical: dbt-fabric.debruyn.dev. New and significantly expanded pages:

• Comparison: dbt-fabric vs upstream microsoft/dbt-fabric
• Comparison: dbt-fabricspark vs dbt-synapse-spark
• Lakehouse — full FabricSpark setup, configuration, and feature guide
• External tables — OPENROWSET-based external table workflow
• Purview integration — end-to-end metadata sync setup
• Cluster by
• Statistics
• Catalog stats
• Limitations — explicit unsupported features per adapter
• Compatibility matrix — dbt Core / Python / adapter version table
• Packages index + 7 per-package pages
• Configuration — substantially rewritten with database/lakehouse tabs
• Python models — updated for current Livy behavior

Dependencies

• Bumped dbt-core to 1.11.10
• Bumped dbt-adapters to 1.23.0
• Bumped mssql-python to 1.6.0
• Security fixes via dependency bumps

Tooling and CI

• Devcontainer for cloud development environments (Codespaces, etc.)
• DW and DE integration tests split into separate workflows
• On-demand DE tests via /test-de PR comments
• On-demand DW tests via /test-dw PR comments
• Extensive unit test coverage added for adapter internals (Credentials, Adapter, Column, Relation, ConnectionManager, ApiClient, LivySession, FabricSparkCursor)
• Improved FabricSparkCursor PEP 249 compliance