Our engine never sees your warehouse password
datahashi
Blog

#semantic-layer

Posts tagged with #semantic-layer.

Querying

Semantic Query 101: metrics × dimensions × filters

Introduce the semantic query triad so any consumer can ask the same question the same way.
Modeling & metrics

Entities and relationships in the semantic model

Metrics sit on entities. Relationships tell the layer how to join without letting every consumer reinvent the graph.
Strategy & comparisons

Thin layer, thick warehouse: what not to copy

What belongs in your warehouse versus your semantic layer, and why copying logic into both creates drift.
Agents & MCP

Why LLMs invent joins (and how to stop them)

Explain why models invent joins from schemas and how governed metrics remove join invention from the agent loop.
Querying

One request shape for every consumer

Dashboards, APIs, and agents should ask for metrics the same way. One structured request shape keeps definitions stable and tooling simple.
Strategy & comparisons

Semantic layer vs dbt models vs BI cubes

Compare dbt models, BI cubes, and a serving semantic layer so you know what each owns and why agents need a request-shaped contract on top.
Agents & MCP

What is a semantic layer (and why agents need one)

A semantic layer gives agents stable metric definitions, governed access, and one query shape so AI systems stop inventing their own numbers.
Strategy & comparisons

From BI-only semantic layer to agent-ready serving

How to move from a BI-only semantic layer to agent-ready serving without rewriting every dashboard.
Strategy & comparisons

When you do not need a semantic layer yet

Honest signals for postponing a semantic layer versus when agent and multi-consumer chaos makes one urgent.
Strategy & comparisons

Semantic layer vs warehouse-native semantics

Contrast vendor-native semantic features with a portable serving layer that works across warehouses and agent tooling.
Strategy & comparisons

Introducing datahashi

Same metric for humans and AI agents — without hallucinated SQL. A governed semantic layer you author as YAML, publish as an immutable artifact, and query over REST or MCP.