COF-C02 · Question #611
While unloading data into a stage, how can the user ensure that the output will be a single file?
The correct answer is B. Use the COPY Option SINGLE=TRUE. In Snowflake's COPY INTO <location> command, the SINGLE=TRUE copy option forces all unloaded data to be written into a single output file rather than being split across multiple files (which is the default parallel behavior). This is useful when downstream systems require a…
Question
While unloading data into a stage, how can the user ensure that the output will be a single file?
Options
- AUse the copy option files=single.
- BUse the COPY Option SINGLE=TRUE .
- CUse the get option SINGLE-TRUE.
- DUse the GET option FILES-SINGLE.
How the community answered
(18 responses)- A6% (1)
- B89% (16)
- C6% (1)
Explanation
In Snowflake's COPY INTO <location> command, the SINGLE=TRUE copy option forces all unloaded data to be written into a single output file rather than being split across multiple files (which is the default parallel behavior). This is useful when downstream systems require a single file. There is no 'FILES=SINGLE' or 'GET option' for this purpose - GET is used to download files from a stage to a local machine. The correct syntax is within the COPY INTO command using the SINGLE = TRUE option.
Topics
Community Discussion
No community discussion yet for this question.