What is Semantic Layer?
A semantic layer is a single source of truth for business metric definitions that sits between your data warehouse and your BI dashboards.
Definition
A semantic layer is the architectural layer that defines what your business metrics mean — "active customer," "revenue," "churn rate" — in one place. Dashboards and APIs query the semantic layer instead of writing raw SQL against the warehouse. The benefit: every dashboard answers the same question the same way. In 2026 the production options are Cube (open-source, default at Paisol), dbt metrics layer (integrated with dbt), LookML (Looker-specific), and Lightdash. Semantic layers also enable multi-tenant row-level security in embedded analytics products.
Want to ship something with this technology?
Free 30-minute strategy call with a senior engineer. We'll quote your project in writing within 48 hours.
Book My Strategy Call