Introducing MetricFlow, Transform’s open source metric framework.
Build and maintain all of your metric logic in code. Get consistent metrics across every team and every tool.
Powerful semantic models for your metrics
MetricFlow constructs a relational graph of your underlying data model—so you can easily build and aggregate even your most complex metrics to any granularity. Powerful abstractions mean you spend less time configuring data and more time on strategic work.
Pull metrics into downstream applications
With MetricFlow’s API-layer, called MQL (MetricFlow Query Language), connect with a range of downstream tools and express metric requests through various interfaces. MQL eliminates the need for writing (or copy-pasting) SQL into last-mile data analysis tools.
Create a consistent data model across your stack
Stop redefining metric logic in every query. Use MetricFlow to generate data marts (also called denormalized or summary tables) back to your warehouse for your most-popular metrics and dimensions. This keeps your data models consistent and eliminates repetitive work.
Avoid code duplication and simplify queries
Simplify code governance with auto-generated SQL for even for the most complex queries. Optimized for the “DRY (Don’t Repeat Yourself)” principle, MQL (MetricFlow Query Language) helps you avoid code duplication in key workflows that can lead to technical debt and disjointed metric logic.
Bring your own compute
Define new database connectors and optimizations for your unique use cases. MetricFlow supports—and even optimizes—queries to any data warehouse. MetricFlow also has database-specific optimizations for Snowflake, Amazon Redshift, and Google BigQuery.
We started Transform to democratize access to insights. And we believe every modern data team needs a metrics layer to make that vision a reality. We’re sharing our framework with the community so that teams everywhere can experience the transformative power of trustworthy metrics.