Snowpro Associate Platform · Free Practice Question Medium
Question 22
When unloading data from a Snowflake table, what is the target destination for the COPY INTO @stage command?
- A An internal or external stage
- B Another Snowflake table
- C A local file system
- D A data stream
Reveal correct answer
Correct answer: A
Explanation
✅ An internal or external stage
Explanation:
The COPY INTO @stage command in Snowflake is used to unload data from a table into a stage, which acts as a holding area for files before further movement or processing. The target can be:
An internal stage, such as
@my_internal_stageAn external stage, like an S3 bucket or Azure Blob Storage linked via credentials
This enables exporting query results in formats like CSV, JSON, or Parquet.
❌ A local file system – Not supported directly via SQL
❌ Another Snowflake table – Use INSERT INTO ... SELECT instead
❌ A data stream – Not applicable; data streams are used for change tracking, not unloading
You can explore this further in Snowflake’s COPY INTO unloading documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
