Skip to content
SPECIFICTION
Get listed

Malloy vs MetricFlow

Malloy

malloydata.dev

MetricFlow

github.com

Side by side

FigureMalloyMetricFlow
Price from—$100/mo
Free plan—Yes
Free trial—Yes
Open source—Yes
WebYesYes
WindowsYesYes
macOSYesYes
LinuxYesYes
APIYesYes
Self-hostedYesYes
Plans published05
Spec score · Semantic Layer Software7.6 (#18)9.1 (#3)

Plans

Malloy

No plans published.

Malloy pricing →

MetricFlow

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

MetricFlow pricing →

In their own words

Malloy

Malloy is an open source language for describing data relationships and transformations. Users can define reusable calculations, table relationships and business logic in semantic models, then compile queries into SQL optimized for the connected database. The language supports nested datasets and automatically guards against common errors in sums, averages and counts. Supported databases include DuckDB, MotherDuck, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Trino and Presto. DuckDB can read Parquet, CSV and JSON files without additional setup. Malloy offers a Visual Studio Code extension for modeling, querying, transformation and visualization, plus a browser notebook through github.dev that requires a GitHub sign-in. Its Python package loads models, compiles queries and runs statements with DuckDB and BigQuery. The CLI can run Malloy files, build persistent tables and automate transformations and pipelines. The project is free and open source, with web, editor extension, API and self-hosted options, among others. DuckDB connections can disable network access; sandboxed mode also limits file access to allowed directories.

Visit malloydata.dev

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