Answer-first summary for fast verification
Answer: All data from only the newly-added files will be appended to the table.
The correct answer is D because Snowflake maintains load history metadata for files that have been successfully loaded into a table. When the COPY INTO command is executed again without the FORCE option, Snowflake automatically skips files that have already been loaded (the original 10 files) and only loads the newly added files (the additional 10 files). This prevents data duplication. Option A is incorrect because it would load all files, including duplicates. Option B is incorrect because COPY INTO operates at the file level, not the data content level (it doesn't distinguish between 'new customers' and 'updates'). Option C is incorrect because the UNCERTAIN FILES error occurs in different scenarios, not when simply re-running COPY INTO on a stage with previously loaded files.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors using the following command:
COPY INTO my_table FROM @my_stage;
COPY INTO my_table FROM @my_stage;
The next day, the user adds 10 more files to the stage, which now contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same COPY INTO command again, what will happen?
A
All data from all of the files on the stage will be appended to the table.
B
Only data about new customers from the new files will be appended to the table.
C
The operation will fail with the error UNCERTAIN FILES IN STAGE.
D
All data from only the newly-added files will be appended to the table.
No comments yet.