SnowPro Core Certification — Question 575

Which function produces a lateral view of a VARIANT column?

Answer options

• A. GET_PATH
• B. FLATTEN
• C. GET
• D. PARSE_JSON

Correct answer: B

Explanation

The FLATTEN function is specifically designed to create a lateral view of VARIANT columns by expanding nested structures into a set of rows. The other options, GET_PATH, GET, and PARSE_JSON, do not provide this capability, as they are used for different purposes such as retrieving specific elements or parsing JSON data.