--- collection: data-engineering collection_name: Data & Analytics Engineering week_start: 2026-10-26 title: dbt v2 lands as the ecosystem rushes to meet it release_count: 21 generated: 2026-11-02 canonical: https://releases.sh/collections/data-engineering/digest/2026-10-26 --- # dbt v2 lands as the ecosystem rushes to meet it dbt v2 arrived at Summit with a rebuilt SQL engine, a shared adapter layer, and a new YAML dashboard language in dbt Charts, while ClickHouse shipped a cost-based join optimizer that reorders outer and semi joins and Dagster hardened its cloud agents. ### dbt v2 arrives, and the ecosystem reorganizes around it The headline of the week was dbt v2, and dbt Labs spent the week explaining what it changes. The [v2 release itself](https://www.getdbt.com/blog/dbt-v2-fast-parsing-shared-adapters-documentation) collapses the long-running split between two parallel codebases into one shared adapter layer and drops the giant manifest.json from the docs experience. The most tangible payoff is developer feedback speed: a [rebuilt SQL engine that lints up to 250x faster](https://www.getdbt.com/blog/dbt-v2-sql-engine-linting-250x-faster) surfaces errors while you type instead of waiting for a run to fail, and a [built-in DuckDB adapter](https://www.getdbt.com/blog/dbt-duckdb-warehouse-free-data-transformation) means you can run dbt end to end against a local, offline warehouse with a small profile change. That adapter layer has company — [Columnar's production ADBC drivers, now used by dbt v2](https://www.getdbt.com/blog/columnar-adbc-drivers-zero-copy-lessons), are the story of the type-system work that makes zero-copy transfers possible. Adoption paths got attention too. Apache Iceberg is suddenly an afternoon project thanks to a [new dbt catalog configuration](https://www.getdbt.com/blog/apache-iceberg-snowflake-dbt-catalog-configuration), and for teams on a larger footprint, [dbt Mesh running on Iceberg](https://www.getdbt.com/blog/dbt-mesh-snowflake-databricks-iceberg-catalog) demos open data infrastructure composition, while dbt Labs and Fivetran outline [moving workloads onto a data lake model by model](https://www.getdbt.com/blog/dbt-lake-compute-data-lake-workloads) rather than ripping and replacing. State management got a dedicated walkthrough of [what dbt State does for compute and freshness](https://www.getdbt.com/blog/dbt-state-orchestration-jobs-19-to-2). ### AI moves inside the models dbt's AI story this week was less about copilots and more about putting models in the pipeline. Google Cloud's Alicia Williams showed how to [call BigQuery's AI.GENERATE from plain SQL](https://www.getdbt.com/blog/bigquery-generative-ai-dbt-sql-functions), with typed output schemas, incremental blocks, token caps, and dbt tests on model output — no Python service required. Under Armour took a similar instinct further, [materializing Snowflake AI agents as dbt models](https://www.getdbt.com/blog/snowflake-cowork-ai-agents-dbt-materializations) so each one passes review and CI like any table. And dbt Wizard got a design rationale: [an agent built to show its work](https://www.getdbt.com/blog/dbt-wizard-ai-agent-validation-lineage) rather than a general coding agent pointed at a project. The most interesting artifact was an experiment. Serving an [engineered summary through the dbt MCP server](https://www.getdbt.com/blog/context-engineering-experiment-dbt-mcp) cut AI skill cost 48.5% and runtime 43.2% versus pulling raw vendor transcripts, though it lost decisions and job titles along the way. On the debugging side, an MCP-connected agent [diagnoses a broken dashboard in six minutes](https://www.getdbt.com/blog/mcp-ai-agent-dashboard-debugging) by tracing the bad number back through the project. dbt also launched something genuinely new: [dbt Charts](https://www.getdbt.com/blog/dbt-charts-open-source-dashboard-yaml), an open-source YAML language for dashboards that version and deploy alongside your models in the same repo. ### Query engines get smarter about plans, merges, and cost ClickHouse's [cost-based join optimizer](https://clickhouse.com/blog/the-new-cost-based-join-optimizer-with-reordering-support-for-non-inner-joins) now exhaustively reorders inner, outer, semi, and anti joins to find the cheapest valid plan — a meaningful widening of what used to be inner-join-only territory. The company also published the [Agentic Analytics Benchmark](https://clickhouse.com/blog/agentic-analytics-benchmark-jev), whose sobering finding is that retrieval hints leave accuracy flat across 20 models, and expanded [customer notifications for Managed Postgres](https://clickhouse.com/blog/expanding-customer-notifications-managed-postgres) to cover replication slots, failovers, and connection limits. In a different register, ClickHouse introduced [GroeneAI, an autonomous contributor](https://clickhouse.com/blog/meet-groeneai-our-autonomous-contributor-to-clickhouse) behind more than 3,000 merged pull requests. Tinybird answered a practical operational question: [querying system.merges](https://www.tinybird.co/docs/changelog/2026-10-30-october-week-five) to see which long-running merge or mutation is holding up a deployment. The same update cleaned up `system.columns` leakage, fixed stale JSONPaths breaking S3 backfills after a Data Source redeploy, and stopped `tb push` from dropping a Token's row-level filter. ### Dagster hardens the operational edges Dagster's two releases were mostly about things going wrong quietly. [Run action menus that stayed open](https://github.com/dagster-io/dagster/releases/tag/1.13.27) let repeated re-execute clicks launch duplicate runs, and pages crashed outright when IndexedDB was unavailable — both fixed. Dagster also [added protobuf 7 support and retries for code locations that fail to start](https://github.com/dagster-io/dagster/releases/tag/1.13.28), a welcome knob for cloud agents, plus a preview `run_job()` for PipesDatabricksClient and a `dagster-dbt[dbt]` extra for dbt v2. ## Releases covered ### ClickHouse - [The new cost-based join optimizer with reordering support for non-inner joins](https://clickhouse.com/blog/the-new-cost-based-join-optimizer-with-reordering-support-for-non-inner-joins) - [The Agentic Analytics Benchmark: ranking tables and labeling failures with Jev](https://clickhouse.com/blog/agentic-analytics-benchmark-jev) - [Expanding Customer Notifications for ClickHouse Managed Postgres](https://clickhouse.com/blog/expanding-customer-notifications-managed-postgres) - [Meet GroeneAI: our autonomous contributor to ClickHouse](https://clickhouse.com/blog/meet-groeneai-our-autonomous-contributor-to-clickhouse) ### Dagster - [Dagster 1.13.27 fixes duplicate runs from run action menus and IndexedDB crashes](https://github.com/dagster-io/dagster/releases/tag/1.13.27) - [Dagster 1.13.28 adds protobuf 7 support and code location start retries](https://github.com/dagster-io/dagster/releases/tag/1.13.28) ### dbt Labs - [dbt v2 lands: faster parsing, one shared adapter layer, and a docs experience that skips the giant manifest.json](https://www.getdbt.com/blog/dbt-v2-fast-parsing-shared-adapters-documentation) - [dbt v2 rebuilds its SQL engine to make linting up to 250x faster](https://www.getdbt.com/blog/dbt-v2-sql-engine-linting-250x-faster) - [dbt blog shows end-to-end DuckDB workflow with the built-in dbt v2 adapter](https://www.getdbt.com/blog/dbt-duckdb-warehouse-free-data-transformation) - [dbt Blog: Columnar's lessons building ADBC drivers for zero-copy data transfer](https://www.getdbt.com/blog/columnar-adbc-drivers-zero-copy-lessons) - [dbt blog: Apache Iceberg on Snowflake gets simpler with new dbt catalog config](https://www.getdbt.com/blog/apache-iceberg-snowflake-dbt-catalog-configuration) - [dbt Blog explains open data infrastructure with dbt Mesh on Apache Iceberg](https://www.getdbt.com/blog/dbt-mesh-snowflake-databricks-iceberg-catalog) - [dbt Labs and Fivetran outline moving dbt workloads onto the data lake, model by model](https://www.getdbt.com/blog/dbt-lake-compute-data-lake-workloads) - [Optimizing your runs for lower compute, fresher data, and faster iteration with dbt State](https://www.getdbt.com/blog/dbt-state-orchestration-jobs-19-to-2) - [dbt Blog shows how to call BigQuery generative AI functions from plain SQL in dbt pipelines](https://www.getdbt.com/blog/bigquery-generative-ai-dbt-sql-functions) - [dbt Blog: Under Armour uses dbt materializations to ship Snowflake AI agents like tables](https://www.getdbt.com/blog/snowflake-cowork-ai-agents-dbt-materializations) - [Inside dbt Wizard, the AI agent built to show its work](https://www.getdbt.com/blog/dbt-wizard-ai-agent-validation-lineage) - [dbt labs experiment: engineered summaries via dbt MCP cut AI skill cost 48.5%](https://www.getdbt.com/blog/context-engineering-experiment-dbt-mcp) - [How to solve dashboard debugging in six minutes with an MCP-connected AI agent](https://www.getdbt.com/blog/mcp-ai-agent-dashboard-debugging) - [dbt Charts introduces an open-source YAML language for dashboards in dbt repos](https://www.getdbt.com/blog/dbt-charts-open-source-dashboard-yaml) ### Tinybird - [Tinybird adds system.merges query to inspect running merges in a Workspace](https://www.tinybird.co/docs/changelog/2026-10-30-october-week-five)