Question

A data engineer used COPY INTO to unload query results into files in a named internal stage. They now need to download those files from the stage to their local workstation for offline inspection. Which command should they run from SnowSQL?

Accepted Answer

GET @my_stage file:///Users/engineer/downloads/;

Answer

PUT @my_stage file:///Users/engineer/downloads/;

Answer

COPY INTO file:///Users/engineer/downloads/ FROM @my_stage;

Answer

SELECT * FROM @my_stage INTO 'file:///Users/engineer/downloads/';