Question

A data analyst pulls order data from a REST API. Each JSON object represents one order and contains a nested array called 'lineItems', where each element holds a product ID, quantity, and price. The analyst needs to load this into a relational table where each row represents a single product within an order. What transformation must the analyst perform?

Accepted Answer

Flatten (explode) the nested lineItems array so each array element becomes its own row

Answer

Aggregate the lineItems array into a single summed total per order before loading

Answer

Pivot the order records from long format to wide format

Answer

Concatenate all lineItems values into a single delimited string column