What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?
What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?
The recommended Parquet file size for optimizing the number of parallel scanning operations when querying from Snowflake external tables is 256-512 MB. This allows for efficient management of input/output operations and maximizes parallel processing capabilities.
https://docs.snowflake.com/en/user-guide/tables-external-intro.
D https://docs.snowflake.com/en/user-guide/tables-external-intro
D To optimize the number of parallel scanning operations when querying external tables, we recommend the following file or row group sizes per format: Parquet files 256 - 512 MB
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
Answer is D: https://docs.snowflake.com/en/user-guide/tables-external-intro. "Parquet Files, Recommended Size Range: 256-512MB"