Which data type can be used to load semi-structured data files directly, without explicitly describing the hierarchical structure of the data?
Which data type can be used to load semi-structured data files directly, without explicitly describing the hierarchical structure of the data?
The VARIANT data type is specifically designed to handle semi-structured data. It allows for loading data files that do not have a fixed schema, such as JSON, Avro, or Parquet, without needing to describe the hierarchical structure explicitly. TEXT, VARCHAR, and VARBINARY do not have this capability.
Answer B