Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nexerSnow
2 weeks, 4 days agoyaho5
1 month, 2 weeks agonexerSnow
3 months agoMike722
3 months agoSusevini
4 months, 2 weeks agoSusevini
4 months, 2 weeks agoHeetec
7 months, 1 week agoniho1993
7 months, 3 weeks agoMultiCloudIronMan
10 months, 2 weeks ago