Awesome Semantic Layer

A curated list of semantic layer tools, frameworks, and resources.

A semantic layer sits between your data warehouse and consuming applications, providing a consistent, governed interface for metrics and dimensions. It translates business logic into SQL so that dashboards, APIs, and AI agents all query the same definitions.

Contents

• Semantic Layer Engines
• Warehouse-Native Semantic Layers
• BI-Embedded Semantic Layers
• Standards and Specifications
• Learning Resources
• Community

Semantic Layer Engines

Standalone, API-first semantic layers that sit between your warehouse and any consuming application.

• AtScale - Universal semantic layer for enterprise BI. Connects to Snowflake, Databricks, and BigQuery with virtual cube technology.
• Bonnard - Agent-native semantic layer with MCP server, multi-tenant publishable keys, React SDK, and CLI-first deployment.
• Cube - Open-source semantic layer with REST, GraphQL, and SQL APIs. Pre-aggregation caching and multi-tenant security contexts.
• dbt Semantic Layer - MetricFlow-powered metrics definitions integrated into the dbt workflow. Requires dbt Cloud for serving.
• Honeydew - Semantic layer native to Snowflake with a visual modeling interface.
• Kyligence - AI-augmented semantic layer with OLAP acceleration.
• Malloy - Semantic data language from Google that compiles to SQL. Open source.
• MetriQL - Open-source metrics store for defining metrics as code. Integrates with dbt.
• Synmetrix - Open-source semantic layer built on Cube with a web-based UI for metric management.

Warehouse-Native Semantic Layers

Semantic modeling built directly into cloud data platforms.

• Databricks Metric Views - Unity Catalog metric definitions for the Databricks lakehouse.
• Google BigQuery Semantic Layer - Looker-powered semantic modeling on BigQuery.
• Snowflake Semantic Views - Native semantic modeling in Snowflake with Cortex Analyst integration.

BI-Embedded Semantic Layers

Semantic layers tightly coupled to a specific BI or analytics platform.

• Bonnard - Embeddable semantic layer with React SDK, markdown dashboards, and multi-tenant publishable keys.
• GoodData - Semantic layer with embedded analytics and multi-tenant support.
• Looker / LookML - Proprietary semantic modeling language embedded in Google's BI platform.
• Power BI Semantic Model - DAX-based semantic modeling in Microsoft's BI stack.
• Sigma Computing - Cloud-native analytics with semantic layer integration for Snowflake.
• Tableau Semantic Layer - Calculated fields and data models within Tableau.

Standards and Specifications

Open standards for defining and exchanging semantic models across platforms.

• Open Semantic Interchange (OSI) - Interoperability spec for exchanging semantic models between platforms.
• Semantic Modeling Language (SML) - Apache-licensed open standard for portable semantic layer definitions.

Learning Resources

Articles

• Semantic Layer Architectures Explained - Warehouse-native vs dbt vs Cube comparison.
• Semantic Layer Introduction - dbt Labs on when to adopt a semantic layer.
• Semantic Layers in the Wild - O'Reilly case studies from early adopters.
• Semantic Layers: A Buyers Guide - Strategic comparison of semantic layer options.
• The Current State of Semantic Layers - InterWorks industry overview.
• The Missing Piece of the Modern Data Stack - Benn Stancil on why metrics layers matter.
• What is a Semantic Layer? - Databricks overview of the concept and its evolution.
• Why Semantic Layers Matter - Hands-on tutorial building a semantic layer with DuckDB.

AI and Semantic Layers

• How to Connect an AI Agent to Your Data Warehouse - Tutorial on wiring a semantic layer to an AI agent in 30 minutes.
• The Agentic Future Demands an Open Semantic Layer - Salesforce on open standards for agent interoperability.
• Why Agentic AI Needs a Semantic Core - Cube's perspective on AI agents and semantic layers.
• Why Enterprise AI Agents Need a Semantic Layer - AtScale on enterprise requirements.
• Why Your AI Agents Need a Semantic Layer - How semantic layers solve text-to-SQL governance problems.

Community

• dbt Community Forum - Discussions on MetricFlow and dbt Semantic Layer.
• r/dataengineering - Active discussions on semantic layer implementations.
• Semantic Layer Summit - Annual virtual conference with 10,000+ attendees.
• Semantic Layer Symposium - Academic conference in Vienna.

Contributing

Contributions welcome! Read the contribution guidelines first.