Metriql

What it does

Aggregates

Metriql can programmatically create dbt roll-up models to speed up BI and other data tools.checked 4 Oct 2026

API

The REST API serves datasets from a dbt Core manifest and supports JWT-based authorization when configured with API auth secrets.checked 9 Oct 2026

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.checked 9 Oct 2026

Central metrics

Metriql lets teams define metrics centrally and synchronize them to other tools.checked 4 Oct 2026

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.checked 4 Oct 2026

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.checked 4 Oct 2026

Data warehouse

Metriql works on top of a data warehouse and compiles queries to SQL for the target warehouse.checked 9 Oct 2026

dbt

Metriql integrates with dbt, maps dbt resources as datasets, and can create automatic roll-up models.checked 9 Oct 2026

dbt execution

Metriql does not run dbt Core models; users must run table or incremental models themselves.checked 9 Oct 2026

dbt integration

Metriql integrates with dbt, maps dbt resources to datasets, and can generate roll-up models.checked 4 Oct 2026

Embedded analytics

The REST API can serve as the backend for single-page analytical applications and supports authorization and CORS.checked 9 Oct 2026

Integration maturity

The BI integrations page says all integrations are in alpha.checked 4 Oct 2026

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.checked 9 Oct 2026

Interfaces

The project includes a REST API, JDBC driver, and CLI, and supports embedded analytics through the REST API.checked 4 Oct 2026

Maintainer

The FAQ says LiveRamp acquired Metriql in December 2021 and its teams have maintained it since.checked 9 Oct 2026

Notable limit

Metriql does not run dbt models; users need to run table or incremental models themselves.checked 4 Oct 2026

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.checked 9 Oct 2026

Other integrations

The integrations page lists Google Sheets and JDBC clients including DBeaver and JetBrains DataGrip as ready, and Power BI as in progress.checked 9 Oct 2026

Performance

The FAQ says Metriql acts as a query proxy, does not process queries itself, and maintains pooled connections to the target warehouse.checked 9 Oct 2026

Product

Metriql describes itself as a headless BI and metadata layer for centrally defining metrics and sharing them across data tools.checked 9 Oct 2026

Query execution

Metriql rewrites queries and runs them on the target database; it says it does not embed Trino or process data itself.checked 4 Oct 2026

Security

The REST API supports JWT-based authorization when configured with API auth secrets, and embedded analytics supports authorization and CORS.checked 4 Oct 2026

Support

The documentation invites users to suggest integrations on GitHub and join the Metriql Slack community.checked 9 Oct 2026