Flattening JSON

Problem

The raw telemetry data comes in deeply nested, complicated JSON structures that BI analysts struggle to query. You need to write a view that flattens it. Write a query that outputs concept with the value: "Flattening converts nested JSON hierarchies into tabular, relational rows and columns."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution