← Back to home
Comparison · Analytics

dbt Core vs Hex

A side-by-side editorial comparison of dbt Core and Hex — release velocity, themes, recent moves, and the top alternatives to consider.

dbt Core vs Hex: at a glance

Featuredbt CoreHex
SectorAnalyticsAnalytics
Velocity score6.36.3
Sparks · 30d01
Top themesanalytics-engineering, dbt-fusion, adapters, clickhouseagents, cli, mcp, model-routing
Last editorial update2h ago8d ago
WebsiteVisit →

What is dbt Core?

dbt Fusion's second beta is adapter work: ClickHouse gets materializations, indexes, and catalogs

Fusion 2.0 is in its second beta, and the content has shifted from engine capability to adapter coverage. beta.2 is almost entirely ClickHouse — Dictionary materialization, index definitions, additional settings, a relation-scoped catalog macro that fixes --write-catalog, and a seed nullability fix — plus Entra bearer-token authentication for the Fabric adapter. Behind it sits the August 14 backport wave, which cut releases for 1.1 through 1.8 in a single day to deliver one deprecated-version warning.

Read the full dbt Core trajectory →

What is Hex?

Hex is moving its agent out of the notebook and onto programmable surfaces.

Hex ships a fortnightly digest, and the through-line across the last ten is agent reach. The agent now runs from a CLI and API, appears inside Codex, acts as an MCP client against the user's own apps, can search the web, and can see the generative apps it builds. Alongside that, the model layer has become a customer-facing control: a picker, an admin-set default, Auto with visible attribution, and a rotating roster including Fable 5, Kimi K2.7, Claude Opus 5 and GPT-5.6.

Read the full Hex trajectory →

dbt Core vs Hex: editorial side-by-side

D
dbt Core
ANALYTICS
6.3

dbt Fusion's second beta is adapter work: ClickHouse gets materializations, indexes, and catalogs

◆ Current state

Fusion 2.0 is in its second beta, and the content has shifted from engine capability to adapter coverage. beta.2 is almost entirely ClickHouse — Dictionary materialization, index definitions, additional settings, a relation-scoped catalog macro that fixes --write-catalog, and a seed nullability fix — plus Entra bearer-token authentication for the Fabric adapter. Behind it sits the August 14 backport wave, which cut releases for 1.1 through 1.8 in a single day to deliver one deprecated-version warning.

◆ Where it's heading

The two ends of this project are pulling apart cleanly. Old branches are being prepared for retirement — a deprecation warning fanned across eight of them, Python 3.8 testing dropped from 1.4 through 1.6 — while Fusion accumulates the adapter breadth it needs to be a credible replacement. beta.1 proved the engine could bind without a catalog; beta.2 is the unglamorous follow-through of making a specific warehouse work properly.

◆ Prediction

Expect further beta releases filling in per-adapter gaps rather than new engine capability, and formal end-of-life notices for the branches that just took the deprecation warning.

H
Hex
ANALYTICS
6.3

Hex is moving its agent out of the notebook and onto programmable surfaces.

◆ Current state

Hex ships a fortnightly digest, and the through-line across the last ten is agent reach. The agent now runs from a CLI and API, appears inside Codex, acts as an MCP client against the user's own apps, can search the web, and can see the generative apps it builds. Alongside that, the model layer has become a customer-facing control: a picker, an admin-set default, Auto with visible attribution, and a rotating roster including Fable 5, Kimi K2.7, Claude Opus 5 and GPT-5.6.

◆ Where it's heading

Hex is positioning the agent as a component other systems call rather than a feature users visit. Governance is being built out in parallel — spend limits, credit usage controls, enterprise role-request controls, signed embedding — which is the pattern of a product preparing for programmatic usage it does not directly supervise. The generative-app surface is drifting the same way, from generated output toward editable, brandable, embeddable artifacts.

◆ Prediction

Expect the CLI and API surface to deepen before the notebook UI gains much, with more of Context Studio and app management reachable programmatically, and expect the spend and role controls to keep pace as headless usage grows.

Alternatives to dbt Core and Hex

Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Each card links to a full editorial trajectory and lets you pivot into a head-to-head comparison with either dbt Core or Hex.

See all dbt Core alternatives → · See all Hex alternatives →

Recent activity from dbt Core and Hex

Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.

  1. 1d agodbt CoreFusion beta.2 fills in ClickHouse materializations and catalogs
  2. 5d agodbt Coredbt 1.2.7 backports the deprecated-version warning and old fixes
  3. 5d agodbt Coredbt 1.1.6 backports the deprecated-version warning and old fixes
  4. 5d agodbt Coredbt 1.3.8 backports the deprecated-version warning
  5. 5d agodbt Coredbt 1.4.10 drops Python 3.8 and warns on deprecated versions
  6. 5d agodbt Coredbt 1.5.12 drops Python 3.8 and warns on deprecated versions
  7. 9d agoHexThe Hex Agent reads a whole Slack thread, then opens a notebook
  8. 10d agoHexFast mode, GPT-5.6, and visible model attribution for Auto
  9. 21d agoHexHex Agent becomes callable from the CLI and API
  10. 1mo agoHexEditable generative-app code, and an agent that sees what it builds
  11. 1mo agoHexMore control over credits, thread metadata, and role requests
  12. 1mo agoHexTwo new models and more controls over generative apps

Frequently asked questions

What is the difference between dbt Core and Hex?

They serve adjacent needs but don't currently overlap on shipped themes. dbt Core and Hex are shipping at a similar cadence (velocity 6.3 vs 6.3, both within Sparkpulse's "active" band). See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.

Is dbt Core better than Hex?

Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. dbt Core and Hex are shipping at a similar cadence (velocity 6.3 vs 6.3, both within Sparkpulse's "active" band). For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.

What are the best alternatives to dbt Core?

Top dbt Core alternatives in Analytics are ranked by recent ship velocity. Browse the "dbt Core alternatives" section above for the current picks, or visit /alternatives/dbt-core for the full list with editorial commentary on each.

What are the best alternatives to Hex?

Top Hex alternatives in Analytics are ranked by recent ship velocity. Browse the "Hex alternatives" section above for the current picks, or visit /alternatives/hex for the full list with editorial commentary on each.