What is the recommended purpose of the COPY INTO <location> SINGLE = TRUE; command?
COPY INTO <location> SINGLE = TRUE;
For COPY INTO <location>, setting SINGLE = TRUE unloads table or query results into one output file in the target stage or location rather than multiple files.
COPY INTO <location>
SINGLE = TRUE
Community Discussion