Answer-first summary for fast verification
Answer: The COPY INTO command did not identify any new files since the last load.
The correct answer is that the COPY INTO command did not detect new files after the last load. This command tracks files that have been successfully loaded into the table and skips them in subsequent runs. To alter this behavior, you can use the COPY_OPTIONS 'force' = 'true', which forces the loading of all files in the specified path or pattern, regardless of previous loads.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When using the COPY INTO command to load external CSV files into a Delta table, no data was loaded during the second run. What could be the reason?
A
COPY INTO command is designed for one-time data load only.
B
Executing REFRESH TABLE sales before the COPY INTO command is necessary.
C
The COPY INTO command did not identify any new files since the last load.
D
Enabling the incremental = TRUE option is required to load new files.
E
COPY INTO does not support incremental load; consider using AUTO LOADER instead.