What is the recommended Snowflake data type to store semi-structured data like JSON?
What is the recommended Snowflake data type to store semi-structured data like JSON?
The recommended Snowflake data type to store semi-structured data like JSON is VARIANT. This data type is specifically designed to handle semi-structured data and can natively support formats like JSON, Avro, ORC, Parquet, and XML. It provides efficient storage and querying capabilities for such data.
Answer is correct.
Answer D is correct.
D is correct
D is correct
Object, Variant and Array are the semi structured data types supports in snowflake.
Correct
VARIANT
D . Variant
Variant