Skip to content
SPECIFICTION
Get listed

MetricFlow vs Rill Metrics SQL

MetricFlow

github.com

Rill Metrics SQL

rilldata.com

Side by side

FigureMetricFlowRill Metrics SQL
Price from$100/mo$20/mo
Free planYes—
Free trialYesYes
Open sourceYes—
WebYesYes
WindowsYesYes
macOSYesYes
LinuxYesYes
APIYesYes
Self-hostedYesYes
Plans published53
Spec score · Semantic Layer Software9.1 (#3)7.9 (#15)
DefinitionsMetrics and semantic models can be defined in YAML files in a dbt project.Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git.
IntegrationsOfficial documentation lists downstream integrations including Tableau, Hex, Dot, Mode, and Google Sheets.Documented connectors include ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack.

Plans

MetricFlow

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

MetricFlow pricing →

Rill Metrics SQL

  • Starter$20 a month
  • Growth$30 a month
  • EnterprisePriced on request

Rill Metrics SQL pricing →

In their own words

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

Rill Metrics SQL

Rill Metrics SQL turns data warehouse metrics into governed dashboards, partner embeds, and context for AI agents. Metrics SQL lets users query a metrics view as a table, using its defined dimensions and measures without putting aggregation logic into each query. Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git. Dashboards support pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts. Embedding options include iframes, JWT-secured links, and a headless API, with white-label theming and partner data scoping. Rill documents connectors for ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack. Role-based access controls and YAML policies support row- and column-level security; Metrics SQL APIs inherit metrics-view policies. An MCP server exposes governed metrics to AI agents. Starter is $20 per seat per month and Growth is $30 per seat per month; Enterprise pricing is custom.

Visit rilldata.com