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.
A . True
B . False

View Answer

Answer: B

Explanation:

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.