Looker vs MetricFlow
Looker
cloud.google.comMetricFlow
github.comSide by side
| Figure | Looker | MetricFlow |
|---|---|---|
| Price from | — | $100/mo |
| Free plan | — | Yes |
| Free trial | Yes | Yes |
| Open source | — | Yes |
| Web | Yes | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| iOS | Yes | — |
| Android | Yes | — |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 3 | 5 |
| Spec score · Semantic Layer Software | 8.1 (#11) | 9.1 (#3) |
| Security | Looker documents TLS 1.2 or later for data in transit and AES-256 encryption for locally stored sensitive application data. | dbt Labs reports ISO certifications, a SOC 2 Type II examination, and GDPR compliance for dbt. |
| What it does | Looker helps organizations explore, share, and visualize company data to support business decisions. | MetricFlow is a semantic layer that defines metrics and compiles requests into reusable, warehouse-specific SQL. |
Plans
MetricFlow
- DeveloperFree
- MetricFlowFree
- Starter$100 a month
- EnterprisePriced on request
- Enterprise+Priced on request
In their own words
Looker
Looker helps organizations explore, share, and visualize company data for business decisions. Its LookML semantic models define dimensions, aggregates, calculations, and relationships, then use those definitions to generate SQL queries. Gemini-powered natural-language analytics lets users ask questions, while Dashboard Agents provide summaries and explorations grounded in governed metrics. Looker connects to BigQuery, Spanner, Cloud SQL for MySQL, Cloud SQL for PostgreSQL, and other Google services. The Looker Marketplace offers applications, prebuilt LookML models, visualizations, and actions for delivering data to third-party services. Listed capabilities include hourly refresh, row-level security, scheduled reports, and embedded analytics. Deployment is hybrid, with web, Android, iOS, API, and self-hosted options. Mobile apps let users view Looks and dashboards. Google documents TLS 1.2 or later for data in transit and AES-256 encryption for locally stored sensitive application data. A free 14-day trial is advertised, but there is no free plan. Standard, Enterprise, and Embed each list one production instance, 10 Standard Users, and two Developer Users; their API call allowances differ. Pricing is on request.
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.