SnowPro Advanced Data Engineer

FLATTEN applied laterally to the spoken_languages array returns one row for each array element. Each element is an object containing language and level, and that individual object is exposed through the FLATTEN output column VALUE. Accessing f1.value:language and f1.value:level therefore returns the two required rows and columns. Snowflake documents VALUE as the value of the flattened array or object element.