Video upload date:  · Duration: PT1H46M27S  · Language: EN

An analyst needs to flatten a nested array databricks video

data-analyst video for an analyst needs to flatten a nested array structure within the order_items column of the orders table, so that each item appears as a

This is a dedicated watch page for a single video.

Full Certification Question

An analyst needs to flatten a nested array structure within the order_items column of the orders table, so that each item appears as a separate row. Which function should be used to complete the following SQL query? SELECT order_id , _______ ( order_items ) AS item FROM orders ;