Which command is used to unload files from an internal or external stage to a local file system?
Which command is used to unload files from an internal or external stage to a local file system?
To unload files from an internal or external stage to a local file system, the correct command is GET. The GET command is specifically used for downloading files from a Snowflake stage to a local file system. COPY INTO is used for copying data into a stage but not for unloading it to a local file system, and PUT is used for uploading files to a Snowflake stage. TRANSFER is not a relevant command in this context.
B. GET: https://docs.snowflake.com/en/user-guide/data-unload-snowflake. Table -> Copy into -> Stage -> Get -> Local File System
If I had to choose, I would choose B. COPY INTO - is used to unload data into either internal or external stage, then we use GET to download files from INTERNAL stage into local system, or we use tools provided by external provider to download files. "Bulk unloading process The process for unloading data into files is the same as the loading process, except in reverse: Step 1 Use the COPY INTO <location> command to copy the data from the Snowflake database table into one or more files in a Snowflake or external stage. Step 2 Download the file from the stage: From a Snowflake stage, use the GET command to download the data file(s). From S3, use the interfaces/tools provided by Amazon S3 to get the data file(s). From Azure, use the interfaces/tools provided by Microsoft Azure to get the data file(s)." https://docs.snowflake.com/en/user-guide/data-unload-overview ChatGPT says you can download files from external stage through SnowSQL by using GET command.
PUT and GET do not support transferring data between local and external stages so the right option is A
correct
Correct
Get/Put do not support the external stages
It is C as Get is not used for External Stage
Sorry A - COPY INTO
B correct