Answer-first summary for fast verification
Answer: Insert a colon (:) between the VARIANT column name and any first-level element.
The correct answer is A because Snowflake uses a colon (:) as the path delimiter to traverse semi-structured data in VARIANT columns. According to Snowflake documentation and the community discussion, the syntax is table.column:pathelement1.pathelement2.pathelement3, where a single colon is used after the VARIANT column name to access first-level elements. Option B is incorrect because the colon is used for first-level elements, not specifically second-level. Options C and D are incorrect because Snowflake uses a single colon (:) not a double colon (::) for path traversal in semi-structured data. The community discussion with upvotes confirms that answer A is correct, with users providing the proper syntax and referencing official documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a Snowflake user query and traverse semi-structured data?
A
Insert a colon (:) between the VARIANT column name and any first-level element.
B
Insert a colon (:) between the VARIANT column name and any second-level element.
C
Insert a double colon (::) between the VARIANT column name and any first-level element.
D
Insert a double colon (::) between the VARIANT column name and any second-level element.
No comments yet.