Semantic layers are finally getting opinionated enough to be useful

The semantic layer has been around forever. It's the little translation booth between raw data and the decisions people make with it. For years it sat there like the seatbelt in a self-driving car demo, technically present, mostly ignored. AI is what finally made it necessary.

The numbers are grim. 40% of Databricks users still won't touch dbt. Every BI tool in the org lugs around its own definition of "revenue." You wind up with dozens of dashboards that quietly disagree, like a room full of people who all swear they said the same thing.

AtScale, Stardog, Databricks Unity Catalog Metrics, and the rest let you define a metric once and reuse it everywhere: SQL, DAX, MDX, Python, AI agents. Everyone sells it as no-code BI. The thing it actually fixes is drift. Your human analysts, your ML pipeline, and whatever LLM you point at the warehouse all read one "revenue" the same way, so dashboards and model training data agree for once.

The AtScale and Databricks "Semantic Lakehouse" nails this. Nothing gets shuffled around, aggregates come for free, one set of metric definitions, wired right into Unity Catalog and Spark. AI finally gets solid ground to stand on.