Answer: VARIANT

The VARIANT data type is specifically designed in Snowflake for handling semi-structured data such as JSON, Avro, ORC, and Parquet formats. It allows storage and querying of hierarchical data without requiring a fixed schema. BOOLEAN is for true/false values, NUMBER is for numeric data, and VARBINARY is for binary data - none of these are optimized for semi-structured data ingestion like VARIANT is.

Author: LeetQuiz Editorial Team