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
• Set tags on operation nodes so on-run-start/on-run-end hooks are discoverable when running dbt-core with --use-v2-parser (#16310)

Under the Hood

• Add PyPI banner for dbt-oss mirroring the existing dbt-core banner, without the dbt-core namespace deprecation notice
• Update the release workflow's maturin wheel build to target the Python 3.10 abi3 floor

Contributors

• @Jules-G1
• @aiguofer (#16310)
• @ash2shukla
• @larspettermadsstuen (#15930)
• @sd-db (#16246, #16248)
• @srchilukoori (#15508)
• @tauhidanjum
• @vincent.chan

Original source

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)

Fix the dbt-docs-server Docker image: it now downloads a released dbt binary from the dbt-core GitHub Releases and verifies it against the release's published SHA256SUMS, tracking the newest release carrying a Linux binary instead of pinning a stale version (override with --build-arg DBT_VERSION=). The documented docker build command now works verbatim from either the repo root or the crate directory, a .dockerignore keeps the build context empty, and the image is multi-stage, multi-arch, health-checked, and runs as an unprivileged user. (#15856)

Rename dbt v2 CLI branding from Fusion/dbt-core to dbt (proprietary) and dbt-oss (OSS), updating --version/--help output and several Fusion-branded warning/error messages to say dbt instead.

Contributors

@dbeatty10 (#14556)

@eliasdefaria (#15856)

@joshuataylor (#15856)

@kendru

@koletzilla (#14585)

@raunakkssinghc (#14538)

@sd-db (#15616)

Benjamin Franklin (1706–1790)

Thanks to @jtcohen6 for writing this biography of Benjamin Franklin—a famous Philadelphian, and the namesake of this dbt release.

Benjamin Franklin was a polymath. A successful printer and publisher in Philadelphia, he also worked as a scientist, inventor, philosopher, and politician. He was many firsts: the first Postmaster General of the United States, the first U.S. Ambassador to France (critical in achieving their support for the American Revolution), co-founder of the first secular American university (which became the University of Pennsylvania).

But perhaps Franklin's greatest contribution was to a second: the second constitution of the United States. (The Articles of Confederation, though little remembered today outside high-school history classes, lasted a full 8 years from 1781-1789.) As an elder statesman during the Constitutional Convention, Franklin presided over disagreements and negotiated compromises that, flaws and all, remain with us to this day. As the story goes, when asked what kind of government they had created, Franklin replied: "A republic, if you can keep it."

From one "v2" contributor to another - I hereby move adding to the list of Benjamin Franklin's namesakes: the Institute, the bridge, the parkway, multiple universities, two dozen U.S. counties, the $100 bill, and the final release of dbt v2.0. Seconded. So moved.

Original source

The following product name changes and features are part of dbt Labs announcements at dbt Summit 2026 in Las Vegas, September 15-18, 2026.

Product naming updates

We've updated some of our product names and we're excited to unveil them at dbt Summit! Our docs have been updated to use this terminology:

Previously Now What to know — dbt The industry standard for data transformation, available in self-host and cloud-hosted configurations Fusion, dbt Core v2.x dbt v2 (recommended), dbt OSS (open source, Apache 2.0 only) Check out our blog for more information dbt Core v1.x dbt v1 Remains open source

Two other things moved:

• The GitHub repo for dbt (v1 and v2) is now at dbt-labs/dbt.
• The pip install instructions:
  • dbt v2: pip install dbt (previously installed the dbt platform CLI).
  • dbt v1: pip install dbt-core remains for now, but over time will be migrated to pip install dbt-oss.

Now generally available

• dbt v2.0 is the next major version of dbt, running on a single engine written in Rust. Install it with pip install dbt and run it wherever you deploy dbt: on your laptop, in your virtual private cloud, or on the dbt platform. Read more in dbt v2.0 is GA.
• dbt State skips or clones nodes when the logic and data haven't changed, rather than rebuilding everything on every run. It works locally (dbt v1.7 through v2.0), on the dbt platform, and with external orchestrators. To get started, refer to Setting up dbt State.
• Adapters for dbt v2.0 — Snowflake, BigQuery, Redshift, and Databricks are available for local and platform use.
• DuckDB is available for local use. Refer to Adapter lifecycle and About connections for current status and platform connection support.

In preview and beta

• Private beta: Lake Compute is a dedicated engine, built on DuckDB, that runs dbt models directly against your Apache Iceberg™ tables, priced for transformation and nothing else.
• Private beta: Wizard Desktop runs the same Wizard engine in a native app with rendered tables and charts, inline diffs, and parallel chats. Sign up to get the download link.
• Private beta: ClickHouse connections for dbt v2.0 on the dbt platform. Connect ClickHouse Cloud on a v2 release track using username and password over HTTPS. ClickHouse is also in beta for local use — refer to Connect ClickHouse.
• Beta: Apache Spark adapter for dbt v2.0, for local use (CLI only).
• Public beta: dbt Charts turns YAML into interactive dashboards that query your dbt models directly, so boards stay in sync with the transformations your team already trusts. Develop locally with the dct CLI.

Pre-dbt Summit

• Beta: When dbt State is enabled in a self-managed deployment and your project is connected to the dbt platform, state:* selectors use dbt State as their comparison source, unless a state manifest is explicitly provided. Each node (models, snapshots, seeds, and tests) is compared against its own last execution in the deferral target environment rather than a single manifest.json from the most recent job run. Refer to dbt State-powered state:* selectors for more information.
• New: The dbt State page now includes a Lag tolerance recommendations section that identifies models that could safely tolerate more lag. For each model, it shows the current lag tolerance, the recommended value, the estimated percentage of build time you'd save, and projected build time savings over the next 30 days. You can search by model name or filter by project, and apply recommendations by updating the lag_tolerance config.
• New: The Snowflake adapter now supports the interactive_table materialization in beta on dbt v2 (dbt-snowflake v1.13+), covering both static and dynamic (auto-refreshing) interactive tables. For more information, see Interactive tables.
• Enhancement: When you connect to Snowflake through the Semantic Layer, authentication failures and permission errors now return distinct messages prefixed with [WAREHOUSE_AUTHENTICATION_FAILED] or [WAREHOUSE_PERMISSION_DENIED], so you can tell credential issues apart from missing grants.
• Fix: Saving a job with an invalid day-of-month value such as *,L now shows a validation error and prevents the broken schedule from being saved. Use either * or L in the day-of-month field, not both.
• Behavior change: The Fusion admin permission set is now called v2 Migration Admin. The permissions it grants haven't changed, and existing assignments carry over.
• Behavior change: When you assign a project-scoped permission set to a group or service token, you must now specify either all projects or a specific project. Requests that leave project scope unset return a 400 error. Account-level permission sets such as Billing Admin and Notification Manager are not affected. Existing legacy assignments continue to work until you change them.
• Preview: Explore mode is now available in the dbt Wizard home tab and Studio IDE. Explore mode lets users ask questions of governed production data in plain language, with the SQL or metric definition behind every answer. Read-only users can now be invited to ask questions about your data without a developer license in the Wizard home tab.
• New: Jobs with dbt State enabled now include an Explain tab on the run details page. This tab shows why dbt State rebuilt, reused, or cloned each resource in the run, so you can audit State behavior and debug unexpected decisions directly on the dbt platform. Refer to Monitor dbt State activity for more information.
• Behavior change: The following behavior change flags on the dbt platform Latest release track have reached maturity, switching their default values from false to true. To preserve the previous behavior for any of these flags, set them to false in your dbt_project.yml.
  • skip_nodes_if_on_run_start_fails
  • state_modified_compare_more_unrendered_values
  • require_yaml_configuration_for_mf_time_spines
  • require_batched_execution_for_custom_microbatch_strategy
  • require_nested_cumulative_type_params
  • validate_macro_args
  • require_all_warnings_handled_by_warn_error
• Behavior change: AI features in the dbt platform are being enabled by default. They're already on for new accounts and are rolling out soon to existing accounts. Organizations that opted out stay off, and admins can turn AI features on or off anytime in Account settings. Refer to AI features in dbt platform.
• New: dbt Wizard now uses usage-based billing for dbt-managed AI. Usage is metered per token against your consumption pool, with monthly included usage or a trial to start and admin-set spend limits. Refer to Trial and billing and the Billing and access FAQs.
• New: dbt State onboarding and billing updates:
  • New users can now sign up for a free dbt platform account and start a 30-day dbt State trial through a guided onboarding flow. For details, refer to Setting up dbt State.
  • dbt v1.7-1.12 users who are using the dbt State plugin can now create a free dbt platform account to start a 30-day dbt State trial. For details, refer to Setting up dbt State.
  • dbt State billing is now available for self-serve accounts. You can set up usage-based billing in the Usage-based features dashboard. Note that you're billed per target table that dbt State reuses each day, not per dbt platform seat. Refer to Setting up usage-based billing for more information.
  • Behavior change: The standalone dbt State app (app.state.dbt.com) is being retired and is no longer accepting new users. Existing dbt State app users should create a free dbt platform account to continue using dbt State — your free trial will be extended upon account creation.

Original source

2.0.1

Released 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)

Fix the dbt-docs-server Docker image: it now downloads a released dbt binary from the dbt-core GitHub Releases and verifies it against the release's published SHA256SUMS, tracking the newest release carrying a Linux binary instead of pinning a stale version (override with --build-arg DBT_VERSION=). The documented docker build command now works verbatim from either the repo root or the crate directory, a .dockerignore keeps the build context empty, and the image is multi-stage, multi-arch, health-checked, and runs as an unprivileged user. (#15856)

Rename dbt v2 CLI branding from Fusion/dbt-core to dbt (proprietary) and dbt-oss (OSS), updating --version/--help output and several Fusion-branded warning/error messages to say dbt instead.

Under the Hood

Attribute --infer-schemas columns from declared YAML schema before binding via a CatalogProviderList wrapper, instead of mixing them into InferSchemaRegistry

Contributors

@dbeatty10 (#14556)

@eliasdefaria (#15856)

@joshuataylor (#15856)

@kendru

@koletzilla (#14585)

@maxmalkin

@raunakkssinghc (#14538)

@sd-db (#15616)

Original source

2.0.0

Released 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)

Fix the dbt-docs-server Docker image: it now downloads a released dbt binary from the dbt-core GitHub Releases and verifies it against the release's published SHA256SUMS, tracking the newest release carrying a Linux binary instead of pinning a stale version (override with --build-arg DBT_VERSION=). The documented docker build command now works verbatim from either the repo root or the crate directory, a .dockerignore keeps the build context empty, and the image is multi-stage, multi-arch, health-checked, and runs as an unprivileged user. (#15856)

Rename dbt v2 CLI branding from Fusion/dbt-core to dbt (proprietary) and dbt-oss (OSS), updating --version/--help output and several Fusion-branded warning/error messages to say dbt instead.

Contributors

@dbeatty10 (#14556)

@eliasdefaria (#15856)

@joshuataylor (#15856)

@kendru

@koletzilla (#14585)

@raunakkssinghc (#14538)

@sd-db (#15616)

Original source

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)
• Skip Databricks get_relation_config tag and column-tag metadata queries when the model does not configure tags (#16057)
• Fix state:modified missing a snowflake_interactive_warehouses-only config change, which could cause a --select state:modified run to skip a model whose interactive-warehouse attach/detach reconciliation needed to run
• Fix blank or whitespace-only refresh_warehouse/snowflake_warehouse values being treated as configured, which could bypass interactive_table's target_lag warehouse validation and render an invalid warehouse = clause in generated DDL for both interactive and dynamic tables
• Fix cluster_by change detection for Snowflake dynamic and interactive tables: strip the LINEAR type descriptor SHOW DYNAMIC TABLES wraps cluster_by in, and compare quoted identifiers case-sensitively instead of folding them
• Strip double-quote delimiters from a warehouse name before comparing it case-insensitively during dynamic/interactive table configuration-change detection: SHOW never echoes the quotes back, so a quoted warehouse value never compared equal to its own readback and fired a spurious ALTER on every run
• Treat a single-quoted string literal inside a clustering expression (e.g. to_char(ts, 'MON')) as case-sensitive data during configuration-change detection: the surrounding expression text was folded correctly, but a literal's exact case, and any )/, characters embedded inside it, previously corrupted the comparison and could cause an unnecessary full refresh on every run. Live-verified against Snowflake

Contributors

• @itsnamangoyal (#11798)
• @koletzilla (#14585, #14585)
• @sd-db (#14359, #16097, #16123, #16057)

Original source