Cassandra.ToolsAboutKnowledge Base

Metriql

metriql/metriql (119)
Languages:Kotlin, Java, Jinja, Vue, Javascript
Templates:
License:Business Source

Getting Started

Metriql is an open-source metrics store which allows companies to define their metrics as code and share them across their BI and data tools easily. It uses dbt for the transformation layer and integrate with dbt via its manifest.json artifact. You can learn more about metriql from here.

What is Metriql?

Metriql lets you define your metrics centrally for once and synchronize them globally to every other tool you're using. People talk about metrics and KPIs, not database tables and columns. While there are great tools, such as dbt Core from Fishtown Analytics for the transformation layer, the metadata layer was an unsolved problem. Each BI tool introduces its way of defining metrics and dimensions. Most of them don't provide a well-defined API so that you can share the metrics with the other tools.

We believe that the data warehouse is the single source of truth. As you load tons of data into your data warehouse, it gets hard to maintain and make them useful for your organization. You're also likely to consume the data in a lot of different ways:

  • Business, finance, and marketing departments use Business Intelligence tools.
  • Product managers use product analytics tools.
  • Data analysts use SQL
  • Data scientists use a variety of tools such as Python, R, and APIs.

If you don't have a standardized way of sharing data within your organization, each department will need to introduce its own way of understanding the data, which gets messy and painful to maintain. Metriql solves this exact problem as the metadata layer of your data.

We realize that you may need to transform the data because metric and dimension definitions are only one part of the problem. We don't want to introduce another way to transform the data though, as it's a solved problem with dbt Core. That's why Metriql works as an extension of dbt, you can use dbt to transform the data and implement Metriql in your existing project without learning a brand new technology. If you don't need to transform the data, you can also use dbt's sources for Metriql.

The problem is defined as the missing piece of the modern data stack, and Headless BI. If you haven't read these articles, we strongly advise you to do so.

Integrations

Important Links

FAQ Tutorial for starters Tutorials for dbt users

License

Business Source License 1.1

Licensor: Rakam, Inc.

Licensed Work: metriql version 0.3 The Licensed Work is © 2021 Rakam, Inc.

Additional Use Grant: Usage of the software is free when your application uses the Software for non-production purposes, and a single metriql deployment is connected to a single project. A project is defined as a set a metriql datasets that which can be created from dbt projects using dbt Metadata API (manifest.json target) or a set of metriql YML files. If you purchase the license from the licensor, you may use the software for production purposes and to connect it to multiple dbt projects in a single metriql deployment.

Change Date: August 20, 2025

Change License: Apache License, Version 2.0

For information about alternative licensing arrangements for the Software, please visit https://metriql.com/

For information on the Business Source License, please visit the MariaDB Business Source License FAQ: https://mariadb.com/bsl-faq-adopting/

© 2022 Anant Corporation, All Rights Reserved. All logos, trademarks and registered trademarks are the property of their respective owners.