Holistics vs MetricFlow
Holistics
holistics.ioMetricFlow
github.comSide by side
| Figure | Holistics | MetricFlow |
|---|---|---|
| Price from | $960/mo | $100/mo |
| Free plan | — | Yes |
| Free trial | Yes | Yes |
| Open source | — | Yes |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 5 | 5 |
| Spec score · Semantic Layer Software | 8.4 (#6) | 9.1 (#3) |
| Security | Holistics states that it is GDPR- and SOC 2-compliant and encrypts stored database credentials with AES. | dbt Labs reports ISO certifications, a SOC 2 Type II examination, and GDPR compliance for dbt. |
Plans
Holistics
- Entry$960 a month
- Standard$1,200 a month
- Security Compliance Suite$2,400 a month
- Custom PlanPriced on request
- Embedded AnalyticsPriced on request
MetricFlow
- DeveloperFree
- MetricFlowFree
- Starter$100 a month
- EnterprisePriced on request
- Enterprise+Priced on request
In their own words
Holistics
Holistics is a cloud self-service analytics and business intelligence platform built around a programmable semantic layer. Business users can explore curated datasets and build reports with a drag-and-drop interface without SQL, or ask data questions in plain language and receive answers based on governed business definitions. Data teams can define models, metrics, and dashboards in code and version-control them with Git. Supported SQL sources include PostgreSQL, BigQuery, Snowflake, Databricks, Redshift, SQL Server, MySQL, Presto, Athena, ClickHouse, MotherDuck, and Oracle; listed integrations also include dbt, Slack, Google Sheets, DataHub, and webhooks. Reports export as CSV, Excel, or PDF, with scheduled delivery through Email, Slack, Google Sheets, or SFTP. Holistics says it stores metadata and optional query-result cache that expires after a set period, not raw database data. It lists real-time refresh, row-level security, scheduled reports, and embedded analytics, and states GDPR and SOC 2 compliance. Entry costs $960 a month, or 800 USD per month with annual billing, for 100 reports and the first 10 users.
MetricFlow
MetricFlow is a free, open-source tool from dbt Labs for defining metric logic and generating SQL across data dimensions. Metrics and semantic models are written in YAML within a dbt project, using simple, conversion, cumulative, derived and ratio types. Entity types and parameters construct joins while avoiding fan-out and chasm joins. MetricFlow works with dbt 1.6 and higher and lists Snowflake, BigQuery, Databricks and Redshift, plus Postgres for dbt v1 only. A working dbt project and adapter are required. It is distributed under Apache 2.0 and installs from PyPI with `pip install dbt-metricflow`. The tool does not currently support dbt built-in functions or packages. Custom integrations can use JDBC, ADBC, GraphQL or the Python SDK. The dbt Semantic Layer, powered by MetricFlow, lists integrations including Power BI, Tableau, Google Sheets, Excel, Omni, Hex, Mode and Sigma. MetricFlow is self-hosted and costs nothing; hosted Semantic Layer Starter access is listed at $100 per user/month.