
Cube
7.9#2 in data transformation toolsFrom $40 a monthFree planWebAPILinuxSelf-hosted
Visit

| Fact | Cube | dbt Semantic Layer |
|---|---|---|
| Caching | Cube uses background-refreshed pre-aggregations stored in Cube Store and routes matching queries to those rollups. | MetricFlow can rewrite queries and use caching to reduce latency, compute, and repeated warehouse work. |
| Documentation depth | The documentation covers administration, embedding, APIs, Cube Core, recipes, modeling, joins, measures, dimensions, pre-aggregations, integrations and MCP. | Documentation covers semantic models, entities, dimensions, metrics, CLI commands, manifests, deployment, credentials, tokens, and integrations. |
| Founded | 2019 | 2016 |
| Integrations | Listed data sources include Snowflake, BigQuery, Redshift, Databricks, ClickHouse, PostgreSQL, MySQL, MongoDB, Trino, Presto and AWS Athena. | The product page says the Semantic Layer offers an API, the dbt MCP Server, and dozens of out-of-the-box integrations for BI, notebooks, spreadsheets, embedded analytics, and AI systems. |
| Rating on Capterra | 4.6 out of 5 from 79 reviews | 4.8 out of 5 from 4 reviews. |
Cube suits teams building internal BI or embedded analytics that need governed business definitions shared across dashboards, applications, and AI agents. It also fits teams that want a free starting plan or cloud deployment choices.
The Semantic Layer suits data teams that need governed, consistent metrics for analytics, embedded applications, or AI use cases. It is for organizations already using dbt Starter or Enterprise accounts to define and query metrics.