Cube vs dbt Semantic Layer
Cube
cube.dev
dbt Semantic Layer
getdbt.comSide by side
| Figure | Cube | dbt Semantic Layer |
|---|---|---|
| Price from | $40/mo | $0.09/mo |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | Yes | — |
| Web | Yes | Yes |
| Linux | Yes | — |
| API | Yes | Yes |
| Self-hosted | Yes | — |
| Plans published | 4 | 5 |
| Spec score · Semantic Layer Software | 9.3 (#1) | 9.2 (#2) |
| Spec score · Data Transformation Tools | 9.1 (#4) | 8.9 (#8) |
| 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. |
| Support | Cube lists community support for Free, limited chat and email for Starter, and chat and email plus a dedicated CSM for Enterprise. | The pricing page lists 24x5 support for Starter and priority support with SLAs for Enterprise. |
Plans
dbt Semantic Layer
- DeveloperFree
- dbt State add-on$0.09 a month
- Starter$100 a month
- EnterprisePriced on request
- Enterprise+Priced on request
In their own words
Cube
Cube is an analytics platform with a semantic layer that encodes governed business definitions for dashboards, embedded applications, and AI agents. Cube Cloud supports internal business intelligence and embedded analytics, while Cube Core is the open-source project alongside which the cloud platform is built. The Free plan includes a semantic layer IDE, workbooks, dashboard publishing, semantic model and workbook agents, and analytics chat. Listed data sources include PostgreSQL, Snowflake, ClickHouse, Databricks, BigQuery, MySQL, Oracle, Redshift, MongoDB, and Trino; integrations include dbt, Dagster, Prefect, Airflow, and Coalesce.io. Cube Core processes API requests using pre-aggregated data in Cube Store or raw data in connected databases. Cloud deployment options include a managed multi-tenant service on AWS or GCP, a VPC on AWS, GCP, or Azure, and a customer's cloud through BYOC. Cube lists a free plan, Starter at $40 a month per developer, and Premium at $80 a month per developer.
dbt Semantic Layer
The dbt Semantic Layer centralizes metric definitions on dbt models and handles joins so downstream tools and applications can use metrics consistently. MetricFlow generates SQL at query time from semantic model and metric configurations. Teams define those models and metrics in YAML as version-controlled, lineage-aware code. MetricFlow can optimize joins, rewrite queries to reduce compute and latency, and cache repeated queries. The product offers an API, the dbt MCP Server and integrations for BI tools, notebooks, spreadsheets, embedded analytics and AI systems. GraphQL and JDBC APIs and a Python SDK provide ways to query metrics and dimensions; Claude and ChatGPT can connect to governed metrics through the MCP server. Documented warehouse platforms include Snowflake, BigQuery, Databricks and Redshift. Defining and querying metrics requires a dbt Starter or Enterprise-tier account, and single-tenant accounts need account-representative setup and enablement. Starter includes 5,000 queried metrics per month; Enterprise and Enterprise+ each include 20,000. Starter costs $100 a month per user. The free Developer plan does not list the Semantic Layer.