Question

A data engineer runs COPY INTO to unload a very large query result to an external S3 stage. They omit the SINGLE option (leaving the default) and do not set MAX_FILE_SIZE. After the unload, they observe many output files rather than one. A downstream partner requires that no individual output file exceed 100 MB. Which action correctly enforces this requirement?

Accepted Answer

Set MAX_FILE_SIZE to 104857600 in the COPY INTO statement so Snowflake splits output into files no larger than that size

Answer

Set SINGLE = TRUE so Snowflake produces one file that is automatically capped at 100 MB

Answer

Add PARTITION BY with a column whose cardinality guarantees each partition is under 100 MB

Answer

Reduce the warehouse size so fewer threads write smaller files under 100 MB