Semantic Layer vs Business Glossary
People think a semantic layer is just a business glossary. A glossary explains a word like revenue in plain words. People read it. A semantic layer sets out revenue in code that tools run. It turns the rule into SQL and gives back the number. One says what revenue means. The other works it out.
Semantic Layer
One place that sets the rule for each number. Every tool gets the same answer.
A semantic layer sits between the warehouse and the tools that read it. It defines business numbers once, such as revenue or active users. It also names the fields people group by, such as country or month. Every tool that asks for revenue gets the same answer, worked out the same way. The layer turns each request into SQL.
Business Glossary
A shared list of what a company's key words mean.
A business glossary is a shared list of a company's key words and what each one means. It defines terms like active customer, churn or net revenue in plain language. Each term has an owner who agrees the meaning. Terms are linked to the tables and columns that hold them. It is about meaning, not about the data's structure.
In one line
- Semantic Layer
- One place that sets the rule for each number. Every tool gets the same answer.
- Business Glossary
- A shared list of what a company's key words mean.