True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Loading data into Snowflake does not require that source data files be no larger than 16MB. While a default or recommended practice might be to use 16MB files for optimal performance, Snowflake supports loading files up to a size of 5GB when using Amazon S3, Google Cloud Storage, or Microsoft Azure stages. Therefore, the correct answer is False.
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.
16 Mb is default. It can support till 5GB
Also 16 MB is considered "best practice"
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
B False
B.False