CoursesChallenges

Query Planning Over a Semantic Graph

How a metrics engine turns 'total_revenue by region' into a multi-join SQL plan. Join path resolution, the fan-out join trap, symmetric aggregates, aggregation pushdown, time grain resolution, slice-and-dice semantics, and why you cache a tuple, not a metric.

How a metrics engine turns 'total_revenue by region' into a multi-join SQL plan. Join path resolution, the fan-out join trap, symmetric aggregates, aggregation pushdown, time grain resolution, slice-and-dice semantics, and why you cache a tuple, not a metric.

Advanced8 chapters· 1h 41m· in Semantic & Metrics Layer

Course content

  1. 01How a Metrics Engine Compiles a RequestFree
  2. 02Join Path Resolution🔒
  3. 03The Fan-Out Join Trap🔒
  4. 04Symmetric Aggregates🔒
  5. 05Aggregation Pushdown🔒
  6. 06Time Grain Resolution🔒
  7. 07Slice-and-Dice Semantics🔒
  8. 08Caching at the Semantic Layer🔒

Prerequisites

↗Measures, Metrics, Entities, Dimensions

Read the first chapter free

Start reading now — no account required for the free chapters.

Start: How a Metrics Engine Compiles a Request →More in Semantic & Metrics Layer