← 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 score7.56.3
Sparks · 30d11
Top themesanalytics-engineering, data-transformation, ai-native, open-sourceai-agent, generative-apps, cli-api, byok
Last editorial update7h ago1h ago
WebsiteVisit →

What is dbt Core?

dbt 2.0 ships stable with an official OSS/proprietary split and agentic skill loading

dbt shipped its 2.0 stable release on September 16, the first generational version milestone in the project's history. The release formally renames the CLI: what was 'Fusion/dbt-core' becomes 'dbt' (proprietary) and 'dbt-oss' (open source)—a structural separation that existed in practice but now has an official name. New capabilities include native Databricks metric view materializations, a ClickHouse ADBC driver, and AgentSkill installation from dbt packages gated on a new ai_provider flag.

Read the full dbt Core trajectory →

What is Hex?

Hex's agent now builds complete projects from chat — and is pipelineable via CLI

Hex has completed the pivot from data notebook to AI-first analytics environment. The agent can now build entire Hex projects from a single chat prompt — handling notebook creation, data connections, and generative apps — while also exposing its capabilities programmatically via CLI and API. Enterprises have gained BYOK (bring your own AI provider), spend controls, and versioned eval suites to govern model usage at scale. The generative app surface is the fastest-moving piece, receiving targeted chart controls, direct text editing, and Slack-thread context in rapid succession.

Read the full Hex trajectory →

dbt Core vs Hex: editorial side-by-side

D
dbt Core
ANALYTICS
7.5

dbt 2.0 ships stable with an official OSS/proprietary split and agentic skill loading

◆ Current state

dbt shipped its 2.0 stable release on September 16, the first generational version milestone in the project's history. The release formally renames the CLI: what was 'Fusion/dbt-core' becomes 'dbt' (proprietary) and 'dbt-oss' (open source)—a structural separation that existed in practice but now has an official name. New capabilities include native Databricks metric view materializations, a ClickHouse ADBC driver, and AgentSkill installation from dbt packages gated on a new ai_provider flag.

◆ Where it's heading

The OSS/proprietary split is the architectural move that matters most. dbt Labs is building a commercial product on top of dbt-oss, and 2.0 makes that boundary explicit to the ecosystem. The AgentSkills integration signals that dbt sees AI-assisted data transformation as a core product direction—not an add-on. The ai_provider flag is the gating mechanism through which commercial features will increasingly be differentiated.

◆ Prediction

Expect near-term differentiation between dbt (proprietary) and dbt-oss at the feature level, with AI-native capabilities—AgentSkills, model suggestions, lineage intelligence—landing exclusively in the commercial tier first.

H
Hex
ANALYTICS
6.3

Hex's agent now builds complete projects from chat — and is pipelineable via CLI

◆ Current state

Hex has completed the pivot from data notebook to AI-first analytics environment. The agent can now build entire Hex projects from a single chat prompt — handling notebook creation, data connections, and generative apps — while also exposing its capabilities programmatically via CLI and API. Enterprises have gained BYOK (bring your own AI provider), spend controls, and versioned eval suites to govern model usage at scale. The generative app surface is the fastest-moving piece, receiving targeted chart controls, direct text editing, and Slack-thread context in rapid succession.

◆ Where it's heading

The direction is agent-as-primary-interface: Hex is systematically shifting the interaction layer from 'notebook with AI help' to 'chat prompt builds the entire project,' with the notebook itself becoming an implementation detail the agent manages. CLI and API exposure makes Hex a component in automated data pipelines, not just a GUI tool. Eval suite versioning signals they're building governance infrastructure for teams that need to audit and reproduce AI-generated outputs — a layer most rivals haven't formalized. BYOK and multi-model support (Claude Opus 5, GPT-5.6 Sol/Terra/Luna, Kimi K2.7, Fable 5) signal a model-agnostic platform bet rather than vertical integration with a single provider.

◆ Prediction

The next likely move is scheduled or triggered agent runs — Hex already has CLI/API access and fast mode; the missing piece is cron or pipeline-triggered agent jobs without a human in the loop. Structured approval workflows for agent-built projects (beyond the current 'skip approvals' opt-out) are a plausible follow-on as enterprise procurement requires reproducible controls.

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. 9h agodbt Coredbt v2.0.0
  2. 1d agodbt Coredbt v1.12.5
  3. 1d agodbt Coredbt 2.0.2 internal test publish
  4. 2d agoHexPublish eval suites, skip approvals, and build Hex projects from your chat agent
  5. 5d agodbt Coredbt 2.0 RC2: Snowflake interactive tables + Databricks MV fixes
  6. 7d agoHexMore control over Generative app iteration
  7. 7d agodbt Coredbt 2.0 dev.39 internal publish
  8. 7d agodbt Coredbt 2.0 dev.38 internal publish
  9. 21d agoHexChart controls and easier collaboration
  10. 1mo agoHexStart building an app right from your conversation
  11. 1mo agoHexTune how the agent runs
  12. 1mo agoHexCommand (line) and conquer

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 is currently shipping more aggressively (velocity 7.5 vs 6.3), with 1 editorial sparks in the last 30 days against 1. 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 is currently shipping more aggressively (velocity 7.5 vs 6.3), with 1 editorial sparks in the last 30 days against 1. 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.