Question 380
A local engineer wants to download an already-unloaded CSV file from an internal stage. What command fits?
Explanation
Correct Answer
Correct: retrieving stage files to a client. GET @internal_stage retrieves files from supported internal stages to a local client.
Incorrect Answers
Incorrect in this scenario: COPY INTO @stage FROM query unloads SQL query results into files in a stage; it does not provide retrieving stage files to a client.
Incorrect in this scenario: COPY INTO table loads files from a stage into a table; it does not provide retrieving stage files to a client.
Incorrect in this scenario: CREATE TABLE AS SELECT creates a table from the result of a SQL query; it does not provide retrieving stage files to a client.