What is the MOST performant file format for loading data in Snowflake?

What is the MOST performant file format for loading data in Snowflake?
A . CSV (Unzipped)
B . Parquet
C . CSV (Gzipped)
D . ORC

View Answer

Answer: B

Explanation:

Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query performance, particularly for complex queries on large datasets. Parquet files support efficient compression and encoding schemes, which can lead to significant savings in storage and speed in query processing, making it the most performant file format for loading data into Snowflake.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake Documentation on Data Loading1