Answer: FLATTEN

The FLATTEN function in Snowflake is specifically designed to convert semi-structured data (like JSON, arrays, or objects) into a relational format of rows and columns. It explodes nested structures into separate rows, making the data queryable in a tabular form. The community discussion strongly supports this with 100% consensus on option B, noting that FLATTEN is the correct function for this purpose and that there's no JSON-specific context in the question that would warrant using JSON-specific functions like PARSE_JSON or JSON_EXTRACT_PATH_TEXT. Option A (TABLE) is not a function used for this conversion in Snowflake.

Author: LeetQuiz Editorial Team