Design an analytics events table optimized for columnar storage (like Parquet)

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 an analytics events table optimized for columnar storage (like Parquet). Use nested STRUCTs for user_agent details and geo info, plus an ARRAY for tags. Columnar formats handle nested data efficiently.

Practice This Problem

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