
Explanation:
The question asks which command can be used to unload data into an external named stage in Snowflake. The provided SQL example uses COPY INTO @my_stage FROM my_table, which matches option D. COPY INTO [location] is specifically designed for unloading data from tables to stages (internal or external), making it the correct choice. Option C (COPY INTO [table]) is for loading data into tables, not unloading, so it is incorrect. Options A (PUT) and B (CREATE [object]) are not used for unloading table data to stages; PUT is for uploading local files to stages, and CREATE is for creating objects. The community discussion shows 80% support for D alone, with some (20%) suggesting CD, but C is clearly incorrect for unloading, so only D is correct.
Ultimate access to all questions.
No comments yet.