← Back to home
Comparison · Analytics

dbt Core vs Lightdash

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

dbt Core vs Lightdash: at a glance

Featuredbt CoreLightdash
SectorAnalyticsAnalytics
Velocity score6.36.3
Sparks · 30d01
Top themesfusion-migration, v2-transition, semantic-layer, adaptersbusiness intelligence, semantic layer, ai agents, mcp
Last editorial update14d ago3d ago
WebsiteVisit →—

What is dbt Core?

dbt's 1.x releases now point users at v2 straight from the command line.

dbt 2.0 GA split the project into a proprietary 'dbt' binary and dbt-oss, and the 2.0 dev channel has since added read-only Databricks Unity Catalog access through Lake Compute. The 1.x line is still shipping: 1.13.0b1 adds an opt-in --use-v2-parser that hands parsing to the Fusion parser, and today's 1.12.6 prints a v2 availability notice on dbt --version and relays Fusion parser logs through the otel log format.

Read the full dbt Core trajectory →

What is Lightdash?

Lightdash opens AI-built chart types to every cloud user, through the app or MCP.

Lightdash is an open-source BI layer that is turning its semantic layer into a workspace for AI agents. Chart Studio, where users describe a chart and Lightdash builds a reusable project-level chart type, is now available to all cloud users, including from Claude through the Lightdash MCP. It follows agent skills, which let teams save parameterized analysis procedures.

Read the full Lightdash trajectory →

dbt Core vs Lightdash: editorial side-by-side

D
dbt Core
ANALYTICS
6.3

dbt's 1.x releases now point users at v2 straight from the command line.

◆ Current state

dbt 2.0 GA split the project into a proprietary 'dbt' binary and dbt-oss, and the 2.0 dev channel has since added read-only Databricks Unity Catalog access through Lake Compute. The 1.x line is still shipping: 1.13.0b1 adds an opt-in --use-v2-parser that hands parsing to the Fusion parser, and today's 1.12.6 prints a v2 availability notice on dbt --version and relays Fusion parser logs through the otel log format.

◆ Where it's heading

The 1.x branch is being turned into an on-ramp for v2: a PyPI banner in 1.12.5, a CLI notice in 1.12.6, deprecated-version warnings and the Fusion parser opt-in in 1.13. Meanwhile 2.0 work concentrates on adapter parity (ClickHouse, Databricks) and Lake Compute.

◆ Prediction

Expect 1.13 to reach GA with the v2 parser opt-in and more migration prompts, and 2.0.x to extend Lake Compute past read-only Unity access. The entries don't show an end-of-life date for 1.x.

L
Lightdash
ANALYTICS
6.3

Lightdash opens AI-built chart types to every cloud user, through the app or MCP.

◆ Current state

Lightdash is an open-source BI layer that is turning its semantic layer into a workspace for AI agents. Chart Studio, where users describe a chart and Lightdash builds a reusable project-level chart type, is now available to all cloud users, including from Claude through the Lightdash MCP. It follows agent skills, which let teams save parameterized analysis procedures.

◆ Where it's heading

Lightdash is moving AI from answering questions to extending the product itself: custom chart types, reusable agent skills, and native YAML that removes dbt as a prerequisite. Governance features such as verified content give teams a way to trust what the agents produce.

◆ Prediction

Expect more agent features exposed through MCP, so external assistants can create and govern Lightdash content, and a shared library for Chart Studio chart types.

Alternatives to dbt Core and Lightdash

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 Lightdash.

See all dbt Core alternatives → · See all Lightdash alternatives →

Recent activity from dbt Core and Lightdash

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

  1. 7d agoLightdash🧩 Chart Studio, now available for all cloud users
  2. 15d agodbt Coredbt 1.12.6 points users to v2 and fixes Fusion parser logging
  3. 15d agodbt Coredbt 1.11.16 fixes nested wildcard selectors, adds tarball path check
  4. 15d agodbt Coredbt-core 1.13 beta adds opt-in Fusion parser and dbt login
  5. 23d agoLightdash🎓 Teach your AI agents reusable skills ⚡
  6. 1mo agodbt CoreLake Compute gains Databricks Unity Catalog read access
  7. 1mo agoLightdash🪆 Explore nested and repeated columns
  8. 1mo agoLightdash✅ Promote, own, and find verified content
  9. 1mo agodbt Coredbt v2.0.0 ⚡
  10. 1mo agodbt Coredbt v1.12.5
  11. 1mo agoLightdash🔌 Test your warehouse connection before you save it
  12. 1mo agoLightdash💬 A comments panel for your dashboards

Frequently asked questions

What is the difference between dbt Core and Lightdash?

They serve adjacent needs but don't currently overlap on shipped themes. dbt Core and Lightdash 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 Lightdash?

Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. dbt Core and Lightdash 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 Lightdash?

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