Design a semantic layer metrics table

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

Design a semantic layer metrics table. Create a metric_definitions table that stores business metric definitions (name, SQL expression, description, owner) as a catalog of agreed-upon metrics.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.