Why these posts

A semantic layer succeeds or fails on details that do not show up in a vendor demo: whether a metric keeps its meaning when it is sliced a new way, whether access rules follow the definition into every tool, and whether an AI agent resolves a question through an endorsed definition or invents its own formula from column names. The list below starts with the basic vocabulary, moves to running the layer in production, then covers what changes when agents become the main consumer, and ends with the open standards that keep your definitions portable.

Each link goes to the article's canonical home, usually IcebergLakehouse.com or DataLakehouseHub.com. For short definitions of the terms used in these articles, see theknowledge base.

Start with the foundations

What a semantic layer is, what it is not, and how to build one without repeating the usual mistakes.

  1. What Is a Semantic Layer? A Complete Guide

    What goes into a semantic layer and why self-service analytics and AI agents both depend on it.

    iceberglakehouse.com
  2. The Who, What, and Why of Semantic Layers

    Who owns the layer, what it holds, and why it decides whether your numbers can be trusted.

    iceberglakehouse.com
  3. Semantic Layer vs. Metrics Layer: What's the Difference?

    Where the two overlap, where they differ, and when you need both.

    iceberglakehouse.com
  4. Semantic Layer vs. Data Catalog: Complementary, Not Competing

    One defines what data means, the other inventories what exists.

    iceberglakehouse.com
  5. How to Build a Semantic Layer: A Step-by-Step Guide

    From picking the first metrics to views, documentation, and access policies.

    iceberglakehouse.com
  6. Semantic Layer Best Practices: 7 Mistakes to Avoid

    A checklist of the naming, modeling, and policy mistakes that make a layer unreliable.

    iceberglakehouse.com

Governance and operations

Running a semantic layer day to day: access rules, documentation, and one model over data that lives in more than one place.

  1. The Role of the Semantic Layer in Data Governance

    Central definitions, row-level security, column masking, and traceability.

    iceberglakehouse.com
  2. How a Self-Documenting Semantic Layer Reduces Data Team Toil

    Generated descriptions and metadata propagation instead of a wiki nobody updates.

    iceberglakehouse.com
  3. Data Virtualization and the Semantic Layer: Query Without Copying

    Virtual datasets and acceleration in place of pipelines that copy data around.

    iceberglakehouse.com
  4. Semantic Layer Federation: One Meaning for Data That Lives Everywhere

    One set of governed metric definitions across multi-cloud data.

    iceberglakehouse.com
  5. Semantic Layer Federation: One Logical Model Over Data on Three Clouds

    Pushdown, egress, acceleration, and where semantic federation still breaks.

    iceberglakehouse.com

Semantic layers and AI agents

Why an agent pointed at raw schemas guesses, and what changes when it resolves questions through governed definitions.

  1. Why Your AI Initiatives Fail Without a Semantic Layer

    How models write wrong SQL without business context, and how grounding fixes it.

    iceberglakehouse.com
  2. Why Semantic Layers Make Enterprise Text-to-SQL Safer

    Text-to-SQL accuracy with and without a semantic layer, across several platforms.

    iceberglakehouse.com
  3. The Semantic Layer as a Translation Engine: Bridging Natural Language and SQL

    How metric definitions and documentation turn business language into correct SQL.

    datalakehousehub.com
  4. Composable Semantic Layers for Analytical Agents

    Why agents need business logic that survives multi-step analysis, not just a list of metric names.

    datalakehousehub.com
  5. The Metric Contract Mandate: Standardizing Semantic Layers Before AI Agent Access

    What to standardize before you let an agent query your metrics.

    iceberglakehouse.com
  6. Metric Contracts as the Interface AI Agents Actually Need

    Calculation, grain, time semantics, ownership, versioning, and tests as one contract.

    iceberglakehouse.com
  7. Why Agentic AI Needs a Governed Semantic Layer Behind the Model Context Protocol

    MCP carries the connection; the semantic layer carries the meaning and the access rules.

    iceberglakehouse.com
  8. Composable Analytics with Agents: Leveraging Virtual Datasets and the Semantic Layer

    A worked example of agents building on virtual datasets in a semantic layer.

    iceberglakehouse.com

Open standards and headless BI

Keeping definitions portable: headless BI, Apache Ossie, and where semantic models sit in an open lakehouse.

  1. Headless BI: How a Universal Semantic Layer Replaces Tool-Specific Models

    One model served to every tool instead of one model per dashboard product.

    iceberglakehouse.com
  2. Apache Ossie and Apache Polaris: Putting Semantic Models in the Open Catalog

    What the Ossie spec covers, what the catalog stores, and what is still unfinished.

    iceberglakehouse.com
  3. How Apache Ossie Is Deciding What Agents and BI Tools Can Ask a Semantic Layer

    The layered query design: a constrained dimensional interface and a grain-safe SQL interface.

    iceberglakehouse.com
  4. The Breakdown of the Open Lakehouse in 2026

    Parquet, Iceberg, Polaris, Arrow, and Ossie, and how the five fit into one build.

    datalakehousehub.com

Work with Alex