Notifications
Clear all
Topic starter
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A . VARIANT
B. ARRAY
C. VARCHAR
D. XML
E. BLOB
Suggested Answer: A,B
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
Posted : 19/01/2023 1:25 pm