Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Metriql

metriql.com

  • Free plan
  • Web
  • API
  • Self-hosted
7.3 Club score Visit metriql.com

What Metriql is

Metriql is a free, open-source metrics store and headless BI layer for defining metrics as code and sharing them across business-intelligence and data tools. It integrates with dbt, maps dbt resources to datasets, and can create roll-up models programmatically. Metriql rewrites queries and executes them on the target data warehouse rather than processing data itself. Teams must run their own dbt table or incremental models. The project provides a REST API, JDBC driver, and CLI; its REST API can support embedded analytics with authorization and CORS. Listed database adapters include Postgres, Redshift, BigQuery, Snowflake, Presto, MySQL, SQL Server, Azure SQL, and ClickHouse, though not every dbt adapter is supported. Ready-listed BI integrations include Tableau, Redash, Superset, Mode, Metabase, Looker, Google Data Studio, Google Sheets, and JDBC clients such as DBeaver and DataGrip. The integrations page marks all integrations alpha; Power BI is in progress, while Qlik and MicroStrategy need testing. Deployment supports API, web, and self-hosted use.

Who it suits

Metriql suits business, finance, marketing, product, analytics, and data-science teams sharing governed metrics across tools. It also fits organizations wanting to run an open-source metrics layer in their own infrastructure.

Good to know, and what to watch

  • Defines and synchronizes metrics centrally
  • Integrates with dbt datasets
  • Provides REST API, JDBC, and CLI
  • Supports embedded analytics authorization
  • Works with multiple listed warehouses
  • BI integrations are marked alpha
  • Users must run dbt models themselves
  • Not all dbt adapters are supported
  • Power BI integration is still in progress

The verdict

Metriql centralizes metric definitions while leaving query execution on the target warehouse. Its open-source, self-hosted model is flexible, but integration maturity and dbt execution responsibilities require planning.

What the maker publishes

Aggregates
Metriql can programmatically create dbt roll-up models to speed up BI and other data tools. source
API
The REST API serves datasets from a dbt Core manifest and supports JWT-based authorization when configured with API auth secrets. source
BI integrations
The integration list marks Tableau, Redash, Superset, Mode, Metabase, Looker, Google Data Studio, and others as ready; Power BI is in progress and Qlik and MicroStrategy need testing. source
BI integrations
The integrations page lists Tableau, Redash, Superset, Mode Analytics, Metabase, Looker, and Google Data Studio as ready; it says integrations are in alpha. source
Central metrics
Metriql lets teams define metrics centrally and synchronize them to other tools. source
Database support
The listed adapters include Postgres, Redshift, BigQuery, Snowflake, Presto, MySQL, SQL Server, Azure SQL, and ClickHouse; the page notes that not all dbt adapters are supported. source
Data handling
Metriql's privacy policy says its connectors may cache data in short-lived encrypted caches and that data almost always remains in the user's environment. source
Data warehouse
Metriql works on top of a data warehouse and compiles queries to SQL for the target warehouse. source
dbt
Metriql integrates with dbt, maps dbt resources as datasets, and can create automatic roll-up models. source
dbt execution
Metriql does not run dbt Core models; users must run table or incremental models themselves. source
dbt integration
Metriql integrates with dbt, maps dbt resources to datasets, and can generate roll-up models. source
Embedded analytics
The REST API can serve as the backend for single-page analytical applications and supports authorization and CORS. source
Integration maturity
The BI integrations page says all integrations are in alpha. source
Intended users
The docs describe use by business, finance, and marketing teams using BI tools, product managers using analytics tools, analysts using SQL, and data scientists using Python, R, and APIs. source
Intended users
The introduction describes use by business, finance, and marketing teams with BI tools, product managers with analytics tools, analysts using SQL, and data scientists using Python, R, and APIs. source
Interfaces
The project includes a REST API, JDBC driver, and CLI, and supports embedded analytics through the REST API. source
Maintainer
The FAQ says LiveRamp acquired Metriql in December 2021 and its teams have maintained it since. source
Notable limit
Metriql does not run dbt models; users need to run table or incremental models themselves. source
Open source
The FAQ describes Metriql as open-source and says it can be run in a company's own infrastructure or served to its customers. source
Other integrations
The integrations page lists Google Sheets and JDBC clients including DBeaver and JetBrains DataGrip as ready, and Power BI as in progress. source
Performance
The FAQ says Metriql acts as a query proxy, does not process queries itself, and maintains pooled connections to the target warehouse. source
Product
Metriql describes itself as headless BI and an open-source metrics store for defining metrics as code and sharing them across BI and data tools. source
Product
Metriql describes itself as a headless BI and metadata layer for centrally defining metrics and sharing them across data tools. source
Query execution
Metriql rewrites queries and runs them on the target database; it says it does not embed Trino or process data itself. source

Checked against the maker's pages on 9 Oct 2026.