Which Snowflake data type is used to store JSON key value pairs?
Which Snowflake data type is used to store JSON key value pairs?
The appropriate Snowflake data type for storing JSON key-value pairs is VARIANT. In Snowflake, the VARIANT data type is designed to store semi-structured data, including JSON. While the OBJECT data type can also store key-value pairs, VARIANT is more versatile as it can store values of different types, including arrays and other nested structures.
D is correct https://docs.snowflake.com/en/sql-reference/data-types-semistructured VARIANT and OBJECT can contain key-value pairs