dbt Release Notes

2.0.0-dev.41

Released September 23, 2026

Features

• [Lake Compute] Read AWS Databricks Unity Catalog tables using Databricks profile PAT/OAuth M2M credentials, declaration-aware validation, and dbt debug attach parity. Existing fs catalogs.yml entries continue to use type: unity. Existing local Unity attach options in config.lakecompute must move to config.duckdb; Lake Compute access is read-only and Unity model writes are unsupported.

Fixes

• Fix modules.re functions silently dropping keyword arguments (flags=, maxsplit=, count=) (#15508)
• Emit only changed columns in Databricks column-tag alter diffs (#16246)
• Emit only changed keys in Databricks relation-tag SET TAGS diffs (#16248)
• Implement TableRepr methods index_of_value_in_column and count_occurrences_of_value_in_column to fix Fusion panic in dbt_utils.get_query_results_as_dict()
• Copy config.group onto the top-level group for source and singular tests, matching dbt-core (#15930)
• Make insert_gateway_label idempotent so gateway host resolution no-ops when the label is already present, instead of relying on a caller-side guard …

dbt-core 1.12.5 - September 15, 2026

Fixes

• Fix Dimension to satisfy the metricflow-semantic-interfaces protocol and bump the metricflow floor to 0.213.0 (#, #)

Under the Hood

• Add a banner to the dbt-core PyPI description pointing users to the v2 install docs (#)

Contributors

• @itsnamangoyal (#, #)
• @tauhid621 (#)

dbt 2.0.0 - Benjamin Franklin (September 14, 2026)

Features

• Install agent skills (AgentSkills-format SKILL.md directories) from installed packages and the project's own skill-paths when packages are installed, gated on the new ai_provider flag. (#14556)
• Support native Databricks metric view materializations (#15616)
• [ClickHouse] Connection-level settings (profile custom_settings plus v1-parity synchronous-operation defaults), default database wired to the profile schema, literal '?' in SQL, and dbt identified as dbt/<version> in the HTTP User-Agent (system.query_log.http_user_agent), via the new adbc_clickhouse driver (#14585)

Fixes

• Preserve compiled SQL output for inline compile commands in quiet mode (#14538) …

2.0.0-dev.39

Released September 09, 2026

Features

• [ClickHouse] Connection-level settings (profile custom_settings plus v1-parity synchronous-operation defaults), default database wired to the profile schema, literal '?' in SQL, and dbt identified as dbt/<version> in the HTTP User-Agent (system.query_log.http_user_agent), via the new adbc_clickhouse driver (#14585)

Contributors

• @koletzilla (#14585)

2.0.0-dev.38

Released September 09, 2026

Features

• [ClickHouse] Connection-level settings (profile custom_settings plus v1-parity synchronous-operation defaults), default database wired to the profile schema, literal '?' in SQL, and dbt identified as dbt/<version> in the HTTP User-Agent (system.query_log.http_user_agent), via the new adbc_clickhouse driver (#14585)

Contributors

• @koletzilla (#14585)

2.0.0-dev.37

Released September 09, 2026

Features

• [ClickHouse] Connection-level settings (profile custom_settings plus v1-parity synchronous-operation defaults), default database wired to the profile schema, literal '?' in SQL, and dbt identified as dbt/<version> in the HTTP User-Agent (system.query_log.http_user_agent), via the new adbc_clickhouse driver (#14585)

Contributors

• @koletzilla (#14585)

2.0.0-rc.2

Released September 08, 2026

Features

• [ClickHouse] dbt unit tests are supported; multi-statement SQL containing ClickHouse backslash escapes is now split correctly by the statement splitter (#14585)
• [ClickHouse] table now compatible with MVs (mv_on_schema_change defaults to fail, repopulate_from_mvs_on_full_refresh replays the MV queries), materialized_view supports on_schema_change, in-place refresh-schedule updates (MODIFY REFRESH) with safe transition errors, multi-MV update/rename flows and refreshable: false, and projections accept the index form with up-front validation. (#14585)
• Add beta support for the Snowflake interactive_table materialization, covering static and dynamic interactive tables and config-change detection for target_lag and warehouse settings (#11798)

Fixes

• Respect full refresh when view_update_via_alter is enabled for Databricks views. (#14359)
• Keep column metadata local to each column instead of inheriting parent resource metadata. (#16097)
• Detect Databricks materialized view query changes and require full refresh when compiled SQL changes (#16123) …

dbt-core 1.12.4 - September 08, 2026

Features

• Add otel_trace_id() and otel_span_id() Jinja functions to correlate query comments and model SQL with OpenTelemetry trace/span ids (#)

Fixes

• Re-parse the built-in generic tests (test_not_null, test_unique, test_accepted_values, test_relationships) after loading a Fusion-generated manifest, so they are not permanently evicted and left undefined at test-compile time (#15914)
• Write target/manifest.json from the corrected in-memory manifest after loading a Fusion-generated manifest, so the on-disk artifact reflects the rediscovered adapter macros actually used for compilation instead of Fusion's raw bundled macros (#)
• Capture and re-emit fusion parser subprocess output through dbt-core's event system instead of letting it pass through to raw stdout/stderr, re-leveling each line by its json-compat severity when available (#15672)
• Validate that a resolved package installation path stays within the configured packages-install-path (#N/A)

Under the Hood

• sync JSON schemas from dbt-fusion (#N/A)

Contributors …

2.0.0-dev.35

Released September 03, 2026

Features

• Recognize Databricks persist_constraints and schema.yml meta.constraints so Fusion can persist legacy constraints and unnamed primary-key expressions. (#15773)

Fixes

• Match dbt-databricks table-property comparison by retaining all remote properties and detecting changes to configured properties. (#16051)

Contributors

• @sd-db (#15773, #16051)

2.0.0-rc.1

Released September 02, 2026

Features

• Add Exasol adapter (Phase 1): connection/auth with TLS and timeout profile options, metadata adapter, agate/seed type conversion (incl. HASHTYPE) and typed SQL literals, reserved-keyword auto-quoting, and the full macro bundle — materializations (table/view/incremental append·merge·delete+insert·microbatch), snapshots (timestamp/check, hard deletes), model contracts and constraints, on_schema_change, grants, persist_docs for tables and views, catalog generation, source-freshness, cross-database utils (dateadd/datediff/last_day/hash/bool_or/listagg/safe_cast/equals/split_part), distribute_by/partition_by/primary_key configs, and interactive dbt init setup
• Add Databricks query tags with automatic dbt metadata and profile- and model-level configuration. (#15701)
• Fusion accepts Databricks Python environment_key and environment_dependencies and uses them on serverless job submit (https://github.com/databricks/dbt-databricks/issues/1636). (#15966)
• Add parse-safe views (dbt.graph_nodes, dbt.models, dbt.seeds, dbt.tests, dbt.snapshots, dbt.sources, dbt.analyses, dbt.operations, dbt.functions, dbt.columns) so standalone querying of an exported index (views.sql) never silently exposes a compile-only or never-populated column at parse time. …

2.0.0-dev.34

Released August 31, 2026

Features

• Add Exasol adapter (Phase 1): connection/auth with TLS and timeout profile options, metadata adapter, agate/seed type conversion (incl. HASHTYPE) and typed SQL literals, reserved-keyword auto-quoting, and the full macro bundle — materializations (table/view/incremental append·merge·delete+insert·microbatch), snapshots (timestamp/check, hard deletes), model contracts and constraints, on_schema_change, grants, persist_docs for tables and views, catalog generation, source-freshness, cross-database utils (dateadd/datediff/last_day/hash/bool_or/listagg/safe_cast/equals/split_part), distribute_by/partition_by/primary_key configs, and interactive dbt init setup
• Add Databricks query tags with automatic dbt metadata and profile- and model-level configuration. (#15701)
• Fusion accepts Databricks Python environment_key and environment_dependencies and uses them on serverless job submit (https://github.com/databricks/dbt-databricks/issues/1636). (#15966)
• Add parse-safe views (dbt.graph_nodes, dbt.models, dbt.seeds, dbt.tests, dbt.snapshots, dbt.sources, dbt.analyses, dbt.operations, dbt.functions, dbt.columns) so standalone querying of an exported index (views.sql) never silently exposes a compile-only or never-populated column at parse time. …

2.0.0-dev.33

Released August 31, 2026

Features

• Add Exasol adapter (Phase 1): connection/auth with TLS and timeout profile options, metadata adapter, agate/seed type conversion (incl. HASHTYPE) and typed SQL literals, reserved-keyword auto-quoting, and the full macro bundle — materializations (table/view/incremental append·merge·delete+insert·microbatch), snapshots (timestamp/check, hard deletes), model contracts and constraints, on_schema_change, grants, persist_docs for tables and views, catalog generation, source-freshness, cross-database utils (dateadd/datediff/last_day/hash/bool_or/listagg/safe_cast/equals/split_part), distribute_by/partition_by/primary_key configs, and interactive dbt init setup
• Add Databricks query tags with automatic dbt metadata and profile- and model-level configuration. (#15701)
• Fusion accepts Databricks Python environment_key and environment_dependencies and uses them on serverless job submit (https://github.com/databricks/dbt-databricks/issues/1636). (#15966)
• Add parse-safe views (dbt.graph_nodes, dbt.models, dbt.seeds, dbt.tests, dbt.snapshots, dbt.sources, dbt.analyses, dbt.operations, dbt.functions, dbt.columns) so standalone querying of an exported index (views.sql) never silently exposes a compile-only or never-populated column at parse time. …

2.0.0-dev.30

Released August 27, 2026

Features

• Add Exasol adapter (Phase 1): connection/auth with TLS and timeout profile options, metadata adapter, agate/seed type conversion (incl. HASHTYPE) and typed SQL literals, reserved-keyword auto-quoting, and the full macro bundle — materializations (table/view/incremental append·merge·delete+insert·microbatch), snapshots (timestamp/check, hard deletes), model contracts and constraints, on_schema_change, grants, persist_docs for tables and views, catalog generation, source-freshness, cross-database utils (dateadd/datediff/last_day/hash/bool_or/listagg/safe_cast/equals/split_part), distribute_by/partition_by/primary_key configs, and interactive dbt init setup
• Add parse-safe views (dbt.graph_nodes, dbt.models, dbt.seeds, dbt.tests, dbt.snapshots, dbt.sources, dbt.analyses, dbt.operations, dbt.functions, dbt.columns) so standalone querying of an exported index (views.sql) never silently exposes a compile-only or never-populated column at parse time.
• [ClickHouse] New configs available: definer, sql_security, inserts_only. Available but not working yet: projections, codec. (#14585)
• Track ref()/source()/this call provenance during Jinja rendering (on_this_reference listener hook), powering the dbt.hard_coded_reference (DBT05) lint rule (#16080)

Fixes …

dbt-core 1.12.3 - August 20, 2026

Fixes

• Send the x-ms-blob-type: BlockBlob header and accept 201 Created when uploading artifacts to an Azure Blob Storage signed URL, so artifact ingestion no longer fails with 400 MissingRequiredHeader on Azure-hosted regions. Upload errors now include the storage provider's error code alongside the status code. (#N/A)

Dependencies

• Require sqlparse>=0.5.5,<0.7.0, sqlparse 0.6.0 is the fixed release for CVE-2026-54284, CVE-2026-59893, CVE-2026-59894 and CVE-2026-71491 (parser denial-of-service). (#15988)

Contributors

• @tauhid621 (#N/A)
• @ulixius9 (#15988)