By default, the maximum file size that can be unloaded to a single file in snowflake is

By default, the maximum file size that can be unloaded to a single file in snowflake is
A . 10 MB
B. 16 MB
C. 5 GB for Azure, AWS and GCP

Answer: B

Explanation:

Unloading to a Single File

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 16000000 (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. https://docs.snowflake.com/en/user-guide/data-unload-considerations.html#unloading-to-a-single-file

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments