COF-C02 · Question #179
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
The correct answer is B. JSON D. Avro E. Parquet. Snowflake natively supports several semi-structured file formats for loading data: JSON, Avro, Parquet, ORC, and XML. These formats contain nested or schema-flexible data that Snowflake stores in VARIANT columns. TSV (A) is a structured, delimited flat file format - not…
Question
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
Options
- ATSV
- BJSON
- CPDF
- DAvro
- EParquet
- FJPEG
How the community answered
(40 responses)- A5% (2)
- B90% (36)
- C3% (1)
- F3% (1)
Explanation
Snowflake natively supports several semi-structured file formats for loading data: JSON, Avro, Parquet, ORC, and XML. These formats contain nested or schema-flexible data that Snowflake stores in VARIANT columns. TSV (A) is a structured, delimited flat file format - not semi-structured. PDF (C) and JPEG (F) are binary document/image formats that Snowflake cannot ingest as semi-structured data through standard COPY INTO commands.
Topics
Community Discussion
No community discussion yet for this question.