Semantic Layer

Data Semantic Layer

Definition

An abstraction layer between agents/users and raw databases that provides a structured inventory of available data (data models, measures, dimensions) and a DSL interface for querying. Unlike raw SQL, semantic layers handle joins, filters, and aggregations under the hood, enabling agents to iterate and learn from data interactions.

Examples in the Wild

  • Example 1:SLayer: agent-optimized semantic layer with natural-language memory and model evolution
  • Example 2:Cube: BI-focused semantic layer for static dashboards
  • Example 3:dbt: transformation layer that can feed semantic models