Which Snowflake command can be used to unload the result of a query to a single file?

Question

Kevin Intriago · Accepted Answer

Use COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.

Kevin Intriago · Answer

Use COPY INTO <external stage> followed by a GET command to download the file.

Kevin Intriago · Answer

Use COPY INTO <internal stage> followed by a put command to download the file.

Kevin Intriago · Answer

Use COPY INTO <external stage> with SINGLE = TRUE followed by a PUT command to download the file.

List of questions