Answer: COPY INTO [location]

The question asks which command unloads data from a Snowflake table into files in a Snowflake stage. COPY INTO [location] (option C) is specifically designed for this purpose, allowing data to be unloaded from tables into internal or external stages. The community discussion strongly supports this, with the highest upvoted comment (2 upvotes) explicitly stating 'copy into command' and another detailed comment (1 upvote) citing Snowflake documentation that confirms COPY INTO <location> unloads data into stages. While COPY INTO [table] (option B) is for loading data into tables, not unloading, and CREATE STAGE (option A) and CREATE PIPE (option D) are for creating stages or pipes, not unloading data. The consensus from the discussion (100% community answers for C) and documentation alignment make C the correct choice.

Author: LeetQuiz Editorial Team