
Answer-first summary for fast verification
Answer: CSV
The question asks for the file format that provides the BEST performance for loading data into Snowflake. Based on the community discussion and Snowflake documentation, CSV (specifically Gzipped CSV) is the most performant format for data loading. The comment from SV1122 with 3 upvotes provides authoritative evidence that 'Loading from Gzipped CSV is several times faster than loading from ORC and Parquet at an impressive 15 TB/Hour.' While Parquet and ORC are columnar formats that offer good query performance, they are not optimal for the loading phase itself. The community consensus (100% B in answers_community) and the detailed technical reference to Snowflake's loading performance documentation support CSV as the correct answer for maximum loading throughput.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.