Read 2026-11-03
dbt-labs/metricflow: technical due diligence, read from its repository
What Borehole read in dbt-labs/metricflow's code and history at fe4b8c1: its licence, security advisories, releases, review practice, tests, dependencies and operations. Every finding cites the file and line it rests on. The full report also covers the team and asks the questions the code cannot answer.
| Dimension | Rating |
|---|---|
| Architecture & Codebase — including AI provenance | strong |
| Engineering Process & SDLC Maturity | adequate |
| Product & Engineering Maturity | strong |
| Security & Reliability Posture | strong |
| Observability & Operations | adequate |
| Fit with the Acquirer | not assessable |
What the repository says
LICENSE: Relicensed: AGPL-3.0 → BUSL-1.1 (2023-04-28) → Apache-2.0 (2025-10-14)GOVERNANCE.md:58: names Apache Software Foundation
Architecture & Codebase — including AI provenance
strongmetricflow/dataflow/builder/dataflow_plan_builder.py is 2,496 lines, 29× this codebase's median file
adequateThe median source file here is 86 lines. 76 files exceed 1,000 lines, the largest being 2,496. Size is not a defect on its own — some problems genuinely live in one place — but these are where merge conflicts, review fatigue and single-owner knowledge concentrate, and they are the first thing that slows an inheriting engineer down.
metricflow/dataflow/builder/dataflow_plan_builder.py:1 — 2,496 lines (29× median) |
metricflow/plan_conversion/to_sql_plan/dataflow_to_subquery.py:1 — 2,408 lines (28× median) |
metricflow_semantics/sql/sql_exprs.py:1 — 2,018 lines (23× median) |
tests_metricflow/snapshots/test_predicate_pushdown_rendering.py/SqlPlan/BigQuery/test_saved_query_with_metric_joins_and_filter__plan0.sql:1 — 1,794 lines (20× median) |
tests_metricflow/snapshots/test_predicate_pushdown_rendering.py/SqlPlan/Databricks/test_saved_query_with_metric_joins_and_filter__plan0.sql:1 — 1,794 lines (20× median) |
Engineering Process & SDLC Maturity
adequate15% of recent commits change more than 2,000 lines
adequate59 of 391 commits in the last 24 months changed over 2,000 lines of code, not counting reformatting, renames, vendored or generated code. A change that size is rarely reviewed line by line. Ask how they were reviewed, and what made them that large.
| 59 commits over 2,000 lines |
Product & Engineering Maturity
strongEffort is shifting from building to rewriting
adequateDeleted lines per line added rose from 0.41 to 0.81 between the first and second halves of this history. Rework is normal and often healthy, but a rising ratio means an increasing share of the team's time is spent replacing code that already exists rather than building what does not. Whether that is deliberate repayment or churn is a question for the team.
| first half 0.41, second half 0.81 (split 2024-07-06) |
Security & Reliability Posture
strong12 dependencies float, and no lockfile is committed
adequateDependency versions are declared as ranges and no lockfile is committed, so a build today does not necessarily produce what a build last month produced. That matters twice over in a transaction: the thing being bought cannot be reproduced exactly, and a compromised upstream release arrives without anyone choosing to take it.
requirements-files/requirements.txt:1 — >=4.0 |
requirements-files/requirements.txt:2 — >=3.1.6, |
requirements-files/requirements.txt:3 — >=4.17, |
requirements-files/requirements.txt:4 — >=10.0.0, |
requirements-files/requirements.txt:5 — >=0.28 |
Relicensed: AGPL-3.0 → BUSL-1.1 (2023-04-28) → Apache-2.0 (2025-10-14)
adequateThe root licence changed 2 time(s). Code taken under earlier terms stays under them; check which terms any fork or customer relied on.
1 advisory against this project in the last 24 months, 1 high or critical
adequateThe newest was published on 2026-09-11. A project that publishes advisories is telling its users about its fixes, and the count and pace say how much security work it carries. None of them affects the surveyed version.
| 2026-09-11: GHSA-g857-633q-gjj8 (high), fixed in 0.213.0: Server-Side Template Injection in where-filter rendering leads to arbitrary code execution |
Observability & Operations
adequateNo telemetry or error reporting is wired in anywhere
adequateNone of 5,483 readable files references an instrumentation, metrics or error-reporting library. If this system is in production, nobody learns that it broke from the system itself — they learn it from a customer. That is a reliability finding before it is an observability one.
| searched 5,483 tracked text files for 16 known instrumentation libraries; manifests for metrics, tracing and error-reporting families; locked dependencies for the packages that emit; 0 matched |
No error reporter is wired in
adequateNothing in the service initialises an error reporter (Sentry, Rollbar, Bugsnag, Honeybadger or an APM agent). An exception in production reaches a person only if someone is reading the logs, which usually means a customer reports it first.
| no error reporter initialised |
1 of 2 deployed images carry no version, or `latest`
adequate1 images in the deployment configuration are named without a version or as `latest`. A redeploy can change the software without a commit, a rollback has nothing to roll back to, and nobody can say from the repository what is running.
local-data-warehouses/trino/docker-compose.yaml:6 — image without a version |
Fit with the Acquirer
not assessableNot rated: structurally not assessable from a repository.
Read more, or read your own
The full report on dbt-labs/metricflow: every dimension, the questions for the room, and the audit log.
Survey a repository: free on public repositories. Private code is read on your own machine by a collector whose source you can read first.