Data Architecture & Modeling

Why dimensional, vault, and metric-store paradigms hit the same wall - and the architecture that comes next. From data products to semantic products.

6 posts

Modern data architecture has accumulated layers - catalogs, glossaries, dictionaries, metric stores, lineage tools, observability platforms - each modelling a slice of meaning in its own format. The result is fragmentation that breaks the moment you connect an AI agent: every layer disagrees on what "active customer" means.

This collection rethinks data modelling for the AI era. Posts examine how the typed semantic graph collapses scattered metadata into a single, versioned source of truth; why the 20-year deadlock between dimensional models, data vaults, and lakehouse formats is broken not by another modelling philosophy but by elevating semantics above the physical layer; and how accidental complexity in the modern data stack compounds when every tool encodes meaning independently.

You'll also find architectural deep dives on the enterprise memory graph, the autonomous patterns that maintain it, and the cost equations behind building your own semantic execution layer versus consuming one as governed infrastructure. The thesis across these pieces: the next generation of data architecture is semantic-first - meaning is modelled once, in a typed and reasoning-friendly form, and every downstream consumer compiles through it rather than rebuilding it.

Three gauges labelled dbt Semantic Layer, Cube, and AtScale showing what each pricing meter taxes: query volume, team size, and model richness.
Data Architecture & Modeling 12 Jun 2026

dbt Semantic Layer vs Cube vs AtScale

Three credible semantic layers, three different meters - and the assumption all three share.

Read more
Three generations of semantics-as-code: LookML inside the BI tool, MetricFlow beside the transformations, and an autonomously built compiled graph.
Data Architecture & Modeling 12 Jun 2026

LookML vs dbt Semantic Layer vs a Compiled Semantic Layer

Three generations of semantics-as-code, compared on the axis that decides it: who maintains the model.

Read more
Three warehouse cylinders with semantic-layer bars above them: native views per platform, single-platform incumbents, and one orange graph spanning all three.
Data Architecture & Modeling 12 Jun 2026

dbt Semantic Layer Alternatives for Multi-Warehouse Estates

Six credible options, post-merger - with the constraints each carries.

Read more
A causal chain of business events on top, and the same events flattened into a warehouse table without causal links below.
Data architecture 20 Mar 2026

Events, Triggers, and Causal Chains

Warehouses store events; they lose the arrows. Why typed causal edges in the semantic graph make the hidden logic queryable.

Read more
Two stack diagrams compared - pipeline-first on the left with scattered definitions, semantic-first on the right with one definition flowing from a top semantic layer down through compile targets to data sources.
Data architecture 14 Mar 2026

Why the Future of Data Engineering Is Semantic First

Pipeline-first ships data, not meaning. Semantic-first inverts the stack - SQL becomes the compile target.

Read more
Fourteen disparate tools tangled by chaotic connections collapse into a single clean semantic graph.
Architecture 18 Jan 2026

The Accidental Complexity in Modern Data Stacks

How we ended up with 14 tools to answer one question - and what consolidation looks like.

Read more
A sealed static data-product crate transforming into a living, connected semantic graph.
Strategy 16 Jan 2026

Data Products Are Dead. Long Live Semantic Products.

The data-mesh era is closing. The semantic-product era is opening.

Read more
Three legacy modeling paradigms - Dimensional, Vault, and Metric Store - pressing against a cracked wall that opens onto a flowing semantic graph.
Architecture 08 Jan 2026

Breaking the 20-Year Deadlock in Data Modeling

Why dimensional, vault, and metric-store paradigms all hit the same wall - and what comes next.

Read more
A flat list of metric definitions transforming into a living concept graph with lineage, context, behaviour, and policy orbits.
Architecture 16 Dec 2025

From Metric Stores to Knowledge Machines

Why static metric definitions can't scale to AI - and what replaces them.

Read more

Stop building context twice.

One graph. Every agent compiles through it. Joins proven, policies enforced, SQL emitted.