The JSON Files That Became a Data Mart

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

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

You are given three sample JSON data files from a client's source system: one for orders with embedded customer details and line items, one for products with nested category hierarchies, and one for shipments with address objects and status history arrays. Design a relational data mart from these inputs.

Summary

Three semi-structured inputs. One queryable warehouse.

Practice This Problem

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