MetricFlow

L3 — Unified Semantic Layer Semantic Layer Free (BSL) within dbt BSL-1.1

Semantic layer for defining metrics as code, integrated into dbt. Acquired by dbt Labs and integrated into the dbt Cloud Semantic Layer. License: BSL-1.1 (not OSI-approved). Companion to existing cube and atscale rows.

AI Analysis

MetricFlow is the OSS semantic layer for defining metrics as code — BSL-1.1 license. Acquired by dbt Labs and integrated into dbt Cloud Semantic Layer. Pick MetricFlow for dbt-native semantic-layer workloads where metrics-as-code + dbt integration are the value props. License posture (BSL) is the trade-off.

Trust Before Intelligence

MetricFlow's BSL-1.1 license is the load-bearing trust dimension: not OSI-approved. dbt Cloud Semantic Layer signs BAAs; OSS BSL requires procurement review for SaaS deployments. Technical model (metrics-as-code, semantic graph) is sound; license posture matters more.

INPACT Score

25/36
I — Instant
4/6

Compiled SQL — warehouse-dependent.

N — Natural
5/6

Metric query API + dbt SQL.

P — Permitted
3/6

Warehouse-dependent. Cap rule applied.

A — Adaptive
4/6

Multi-warehouse via dbt connectors.

C — Contextual
5/6

Semantic graph + dimension consistency + dbt lineage.

T — Transparent
4/6

Compiled SQL inspection.

GOALS Score

18/25
G — Governance
3/6

Definitions-as-code. 1/6 -> 3.

O — Observability
3/6

dbt observability. 1/6 -> 3 lenient.

A — Availability
3/6

3/6 -> 3.

L — Lexicon
5/6

Semantic-layer purpose.

S — Solid
4/6

5/6 -> 4.

AI-Identified Strengths

  • + dbt-native semantic layer
  • + Metrics-as-code + version control
  • + Strong dimension consistency
  • + dbt Cloud signs BAAs

AI-Identified Limitations

  • - BSL-1.1 NOT OSI
  • - dbt Cloud commercial path required for SaaS compliance
  • - Smaller commercial vs Cube/AtScale

Industry Fit

Best suited for

dbt-heavy stacksdbt Cloud users for compliance

Compliance certifications

BSL not OSI; dbt Cloud signs BAAs.

Use with caution for

BSL deployment without reviewNon-dbt stacks

AI-Suggested Alternatives

Cube

Cube for vendor-neutral semantic layer. MetricFlow for dbt-native.

View analysis →
AtScale

AtScale for enterprise semantic layer. MetricFlow for dbt-native.

View analysis →

Integration in 7-Layer Architecture

Role: L3 dbt-native semantic layer.

Upstream: dbt model definitions.

Downstream: Metric API + compiled SQL.

⚡ Trust Risks

high BSL not reviewed for SaaS deployment

Mitigation: Procurement review. Use dbt Cloud for SaaS.

Use Case Scenarios

strong dbt-heavy stack adopting metrics-as-code

Native dbt integration.

weak Non-dbt semantic layer

Cube fits better.

Stack Impact

L3 L3 dbt-native semantic layer.

⚠ Watch For

2-Week POC Checklist

Explore in Interactive Stack Builder →

Visit MetricFlow website →

This analysis is AI-generated using the INPACT and GOALS frameworks from "Trust Before Intelligence." Scores and assessments are algorithmic and may not reflect the vendor's complete capabilities. Always validate with your own evaluation.