SemanticLayer
2 items
Series Posts
Part 31: "Last Mile" — Serving Data: Semantic Layers, BI and Data APIs
Rohan wants a metrics endpoint with three handlers. Ingrid wants the three incident numbers defined once, whatever the tool or the slice. Cube defines net revenue, stock availability and conversion over the governed lake and serves them over REST and to Superset; OPA still decides who sees which rows. Semantic layers, ratios and semi-additive measures, caching, data APIs, embedded analytics, reverse ETL and data products.
Part 33: "Context Is the Product" — Metadata, Agents and AI-Assisted Data Engineering
Leadership wants a chat box that answers questions about the business. Rohan plans to hand a model the schema and a read-only SQL user. Ingrid hands it the metric definitions, the contracts and the catalog instead, through an MCP server that decides what may be asked: metadata as context, MCP, governed tools, AI-assisted pipeline work with guardrails, and the three risks: fluent wrong numbers, exfiltration and prompt injection through data.