Lightdash vs Cube
Side-by-side trajectory, velocity, and editorial themes.
Lightdash chips away at the SQL barrier with NL-to-formula table calcs and metric-tree visualization.
The release cadence is high and the work spans three areas: lowering the technical barrier (spreadsheet-style formulas in table calculations, plain references to grand totals), enriching what a chart and dashboard can express (color palettes at every scope, row/column limits, rich-text table cells), and self-serve operability (default user spaces, expiring preview projects, dashboard-version rollbacks that include chart configs). The Canvas now hosts persistent metric trees, hinting at a heavier semantic-layer story.
Lightdash is positioning between a dbt-native semantic layer (where SQL-fluent analysts live) and a self-serve BI tool (where business users live). The intent-driven formula editor and reference-total functions chip away at the SQL prerequisite for table calculations, while Saved Trees push the metric model into something visually editable. Underneath, the platform is doing the unglamorous self-serve work — personal spaces, palette hierarchies, preview hygiene — that BI products need to survive in larger orgs.
Expect the formula editor to grow into broader AI-assisted authoring (filters, joins, custom dimensions) and Saved Trees to evolve into a more general semantic-layer view that consumes from dbt and produces governance artifacts. Color and palette work suggests embedded/customer-facing BI ambitions next.
Cube ships Creator Mode and a Slack agent — embedded BI and agent surfaces in the same month.
Cube is shipping weekly across three coherent fronts: AI agent surfaces (Slack Agent for ad-hoc questions, Analytics Chat under the hood), embedded analytics (Creator Mode lets customers embed the full Cube app, not just dashboards), and the semantic-layer fundamentals (calculated fields in Explore/Workbook, workbook versions, custom chart palettes, refined filtering). Earlier in the period, data masking, the Viewer role, and scheduled-screenshot notifications rounded out the governance and distribution story.
Two compounding bets: (1) the semantic layer + AI agent combination is the moat — every release deepens what an agent or human can do over governed data without writing SQL, and (2) embedding goes from "put a dashboard in your app" to "give your users a full BI app inside your product." These are complementary — Creator Mode is more compelling when the embedded experience can also answer questions in Slack and self-heal queries with calculated fields.
Expect Creator Mode to grow more embedding controls (white-labeling, role mapping, audit) since it's positioned for ISVs serving downstream customers. The Slack Agent likely gets siblings (Teams, in-app chat) and tighter wiring to dashboards so an agent can produce a chart, save it, and share it back. Calculated Fields expansion (filtered measures, more types) is already telegraphed in the release notes.
See more alternatives to Lightdash →
See more alternatives to Cube →