Answer: COPY INTO

The question asks about loading multiple flat files into a single table. The COPY INTO command is specifically designed for bulk loading data from staged files into Snowflake tables. It can efficiently load multiple files from internal or external stages in a single operation. The community discussion unanimously supports option C with 100% consensus, and the detailed explanation confirms that COPY INTO is used after staging files with PUT. Other options are less suitable: PUT (A) only stages files but doesn't load them into tables, INSERT (B) is for inserting individual rows or small datasets, and MERGE (D) is for upsert operations (insert/update) rather than bulk loading.

Author: LeetQuiz Editorial Team