Metriql
metriql.com
- Free plan
- Web
- API
- Self-hosted
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.