Skip to content
SPECIFICTION
Get listed

Looker vs MetricFlow

Looker

cloud.google.com

MetricFlow

github.com

Side by side

FigureLookerMetricFlow
Price from—$100/mo
Free plan—Yes
Free trialYesYes
Open source—Yes
WebYesYes
Windows—Yes
macOS—Yes
Linux—Yes
iOSYes—
AndroidYes—
APIYesYes
Self-hostedYesYes
Plans published35
Spec score · Semantic Layer Software8.1 (#11)9.1 (#3)
SecurityLooker 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 doesLooker 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

Looker

  • EmbedPriced on request
  • EnterprisePriced on request
  • StandardPriced on request

Looker pricing →

MetricFlow

  • DeveloperFree
  • MetricFlowFree
  • Starter$100 a month
  • EnterprisePriced on request
  • Enterprise+Priced on request

MetricFlow pricing →

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.

Visit cloud.google.com

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.

Visit github.com