Get startedGet started for free

Retrieving nested data

Select all of the statements that could be used to select an item's weight from the item_details column of type VARIANT shown below.

{
    "id": "i193j1",
    "size": {
        "weight": 11.4,
        "volume": 27.6
    },
    "price": 119.99
}

This exercise is part of the course

Data Types and Functions in Snowflake

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise