Semantic Layer Design
Metric Catalog Schema Design for Cross-Functional Teams
Omitting any single field from a metric catalog schema causes a predictable governance failure.
Marcus Heiland
· 10 min read
The Semantic Record — Page 3
Data Observability Tools Comparison for SQL Query Tracing
Query tracing reveals why SQL is slow; pipeline tools only catch that it broke.
Priya Subramaniam
Linking BI Dashboard Queries to dbt Model Versions
dbt versioning prevents dashboard breakage when data models change, but only inside dbt itself.
Adaeze Okonkwo
Query Lineage Tracking From Dashboard to Source Table
Trace data movement from source to dashboard to find errors, protect changes, and prove compliance.
Tobias Wrenfield
Reproducing a Metric Value After a Schema Migration
A schema migration can break metrics silently, producing wrong numbers that look plausible.
Adaeze Okonkwo
Saved Query Catalogs for Reproducible Analytical Answers
Shared definitions eliminate conflicting metrics and the trust problems that come with them.
Adaeze Okonkwo
Immutable Query Logs as an Analytical Audit Trail
Cryptographic proof makes audit logs impossible to fake or alter after the fact.
Marcus Heiland
Audit Logging for SQL Queries on Production Databases
Capture who ran production queries—not just that they ran—to survive compliance audits.
Priya Subramaniam