Which command should be used when loading many flat files into a single table?
Which command should be used when loading many flat files into a single table?
The correct command to use when loading many flat files into a single table is 'COPY INTO'. This command is specifically designed for bulk loading data from staged files into database tables. It is optimized for high-performance data loading and is the appropriate choice in this context. The 'PUT' command is used for uploading data files to a stage, 'INSERT' is used for adding rows to a table individually, and 'MERGE' is used to combine two tables based on conditions.
Correct answer
Step 1. Upload (i.e. stage) one or more data files to a Snowflake stage (named internal stage or table/user stage) using the PUT command. Step 2. Use the COPY INTO <table> command to load the contents of the staged file(s) into a Snowflake database table.
Correct