Why aren't data catalogs used as semantic layers?

A data catalog and a semantic layer solve different problems by design. A data catalog is a centralized system for organizing and describing data assets. It inventories what exists, describes it, and governs it. A semantic layer standardizes metric definitions and translates them into query logic. It defines what a metric means and executes that meaning as a query, the same way, every time. Use a catalog to do a semantic layer's job and you get a system cluttered with brittle metric logic it wasn't designed to run. Use a semantic layer to do a catalog's job and you get metric definitions with no record of what data exists underneath them.

Key Takeaways

  • A data catalog answers "what data exists and can I trust it." A semantic layer answers "what does this metric mean and how do I query it consistently."
  • Catalogs store descriptive metadata (glossary terms, ownership, lineage). Semantic layers store executable logic (SQL translations, metric calculations) that BI and AI tools call at query time.
  • The confusion exists because both use words like "definition" and "single source of truth," but a glossary entry is a static sentence while a semantic layer metric is a governed, reusable query.
  • Forcing a catalog to act as a semantic layer produces drift. The glossary says one thing, the BI tool's semantic model says another, and AI agents inherit whichever they find first.
  • The two are complementary, not competitive. A context platform that unifies catalog metadata with semantic definitions is what lets both humans and AI agents work from the same interpretation of data.

Article Contents

What a data catalog is built to do

A catalog's core job is inventory for human users. It answers "what data exists, where does it live, and can I trust it." That means a metadata store, search and discovery, lineage tracking, and a business glossary sitting on top of technical asset descriptions.

The glossary is the piece that gets mistaken for a semantic layer. A glossary term is descriptive metadata: a name, a definition written in prose, an owner, maybe a linked column. It's a sentence a human can read and agree with, but nothing in the catalog turns "active customer: a customer with a purchase in the trailing 90 days" into a SQL query that a BI tool or an AI agent can run. Data discovery focuses on locating and understanding what data exists, and that's a different task from calculating a governed metric on demand.

Catalogs have evolved from purely technical inventories into business catalogs and now context platforms that add quality signals and AI-assisted classification. But even the most advanced catalogs are still built around describing and governing assets, not around answering "give me revenue by region for Q3" with one correct number. That separation is a current design choice, not a fixed limit: some catalog and metadata platforms are starting to add metric or formula features narrowing, but not eliminating, the distinction.

What a semantic layer is built to do

A semantic layer exists to standardize metric definitions once and translate business terms into query logic every time a tool asks. When an analyst types "revenue" into a BI tool, the semantic layer decides which tables to join, which filters to apply, and which SQL to generate, consistently, whether the request came from Looker, a Python notebook, or an AI agent.

This is one reason dbt, Looker, and Cube each ship their own semantic layer rather than relying on a catalog's glossary. Query-time translation requires a live connection to the compute layer, versioned metric logic, and a caching or execution strategy. A catalog's glossary was never wired for that: it describes intent in prose, but has no execution engine to carry that intent through to a query result.

The stakes for getting this translation right are measurable. Anthropic found that giving Claude direct data access without a context platform that includes structured semantics produced roughly 21% accuracy on business queries. Adding this context and skills pushed that to consistently exceeding 95% (Anthropic, "How Anthropic enables self-service data analytics with Claude"). The gap wasn't the model's reasoning ability. It was whether a translation layer existed between the question and the query, and teams evaluating an AI agent's accuracy should check for that layer before assuming the model itself is the problem.

Why catalogs don't become semantic layers by default

Three mechanisms keep the two apart even when a team tries to force them together.

Static terms versus executable logic. A glossary entry is a sentence written once and updated occasionally. A semantic layer metric is a versioned artifact that gets tested, deployed, and re-run on every query. One is documentation to be read. The other is infrastructure to be executed.

Not built for query-time translation. Catalogs are meant for inventory of static assets, read at browse time, when a person is searching for a dataset or checking who owns it. Semantic layers are read at query time, when a BI tool or agent needs an answer in milliseconds. Retrofitting a catalog to serve live query translation means bolting an execution engine onto a system designed for search and lineage, a different engineering problem than the one the catalog was built to solve.

Ownership and update cadence differ. Governance teams own the glossary and typically update it on a slower, more formal review cycle. Analytics engineering teams own the semantic layer's metric logic and ship changes with every sprint, sometimes every day, as the dbt model or Looker LookML changes. Metadata management forces a shared definition into an owned, governed artifact, but that artifact and the executable metric a BI tool calls are governed by different teams on different clocks. Teams should check who has update authority over each system and how often each one is actually revised, since a mismatch in cadence is what produces drift even when everyone agrees on the definition in principle.

The overlap that causes the confusion

Both systems claim to be the "single source of truth." Both use the word "definition." Vendor marketing on both sides leans into this overlap because it's an easy pitch: buy our catalog, get your semantic layer for free, or buy our semantic layer, retire your catalog.

But a glossary's "definition" is a static sentence for humans, and a semantic layer's "definition" is a governed, reusable query for machines. Teams should check which kind of "definition" a vendor is actually describing before assuming one system covers the other's function.

What happens when teams try to force the merge

Glossary drift from BI metric logic. The glossary says "active customer" means one thing. The BI tool's semantic model, updated last sprint, calculates it differently. Nobody reconciles the two because they're owned by different teams on different cadences.

Duplicated governance work. Someone has to approve the glossary definition and someone has to approve the semantic layer's metric logic, twice for the same concept, twice for every change.

Inconsistent AI agent answers. An AI agent given access to both the catalog and the BI semantic layer will pull whichever definition it finds first, or blend them, and produce an answer that's internally consistent but wrong relative to what either system says. AI-ready data requires semantics, quality, and lineage that travel with the asset, and an agent that can't tell which definition is authoritative will generate a number that matches neither source while presenting it with full confidence. GPT-4o and Claude Sonnet 4.5 scored roughly 10-11% on the Spider 2.0 benchmark against real enterprise schemas without context and semantic grounding, rising into the high 70s once governed context and semantics was added. Gartner's Rita Sallam has pointed to this exact failure mode, predicting that organizations prioritizing semantics could raise agentic AI accuracy up to 80% and cut costs up to 60% by 2027 (Gartner, 2026 Data & Analytics Summit).

How the two should actually connect

The catalog holds inventory, lineage, ownership, and quality signals: what exists, where it came from, who's responsible for it, and whether it's trustworthy. The semantic layer holds metric logic and query translation: what a business term means and how to turn it into a query. Each covers a function the other doesn't, so replacing one with the other leaves that function unhandled.

What sits above both is a context platform, that is open by default, that connects metadata, semantics, definitions, and memory in a shared knowledge graph. An enterprise context platform unifies discovery, semantics, and lineage in one graph, giving a human or an AI agent one place to resolve "what does this mean" and "where does this live" without checking multiple systems for conflicting answers. A BI semantic layer standardizes metrics for query translation inside analytics tools, while semantic context that operates at the level of meaning across the entire data estate is the broader structure that ties catalog metadata, metric definitions, and lineage together so every consuming system, BI or AI, reads from the same interpretation. For a deeper look at how a context layer differs mechanically from a semantic layer, see how a context platform/layer differs from a semantic layer. This piece stays narrowly on the catalog-versus-semantic-layer distinction. That one covers context layer versus semantic layer in depth.

Metadata answers what a piece of data is, semantics answer what it means, and the shift from a passive catalog to an active semantic layer is what makes agentic analytics reliable. An agent needs both the inventory and the meaning to act correctly; missing either one leaves it able to find data or define a metric, but not both at once.

A practical way to tell which one you need

Signs you need a semantic layer: multiple BI tools or AI agents compute the same metric differently, analysts spend meetings reconciling conflicting numbers, or you're standing up an AI agent that needs to generate SQL and it keeps guessing at joins.

Common signs your gap is actually a governance gap, not a semantic layer gap: nobody knows which dataset is authoritative, ownership is unclear, lineage is undocumented, or PII classification hasn't happened. That's a catalog problem, solved with data governance workflows that turn definitions into approved, versioned artifacts, not a semantic layer.

If both symptoms show up together, which is common, check whether the fix requires stretching one system past its design or connecting the two through a shared context layer. The latter is usually the more durable option: a context layer built on an open knowledge graph connecting metadata, ontology, semantics and memory with over 130+ connectors and native glossary, classification, and domain primitives lets the catalog's governance and the semantic layer's logic reference the same underlying entities instead of maintaining separate, drifting copies.

Frequently asked questions

Can I just add metric definitions to my data catalog's glossary and call it a semantic layer?

No. A glossary entry is a description a human reads. A semantic layer entry is executable logic a query engine runs. Adding prose definitions to your catalog documents intent, but it doesn't give any BI tool or AI agent a way to generate consistent SQL from that intent, since there's no execution engine behind the glossary field.

Do I need both a catalog and a semantic layer, or can one replace the other?

You need both capabilities, but not necessarily two separate products: asset discovery and governance on one side, and consistent metric definition and computation on the other. Remove either one and the function it performs, inventory and governance on one side, consistent metric calculation on the other, goes unaddressed.

Why do BI tools like dbt, Looker, and Cube each ship their own semantic layer instead of using the catalog?

Because query-time translation requires a live connection to the compute layer and an execution engine, which catalogs don't have. Each BI tool needs its metric logic to run against the warehouse in real time, an infrastructure requirement the catalog's glossary was never designed to meet.

What breaks when AI agents query a catalog that has no semantic layer behind it?

The agent can find and describe data, but it has no governed way to translate a business question into a correct query. It guesses at joins, calculations, and filters, and produces answers that sound confident but don't match what any BI tool or analyst would calculate.

How does a context platform relate to both the catalog and the semantic layer?

A context platform sits above both, unifying the catalog's inventory and lineage with the semantic layer's metric definitions in one graph. It's what lets a human or an AI agent resolve "what does this mean" and "where does this live" from a single source instead of checking two separate systems and reconciling any differences by hand.

Ready for trusted intelligence?
See how Collate helps teams work smarter with trusted data