Question

A data engineer runs COPY INTO to load a batch of CSV files from a cloud storage location into a newly created empty Delta table. The command completes successfully. Later that day, without any new files being added to the source location, the engineer runs the exact same COPY INTO command again. What happens on the second execution?

Accepted Answer

The command processes zero new files and the target table row count remains unchanged.

Answer

The command reloads all the same files, resulting in duplicate rows in the target table.

Answer

The command fails with an error because the files have already been ingested.

Answer

The command truncates the target table and reloads all files from scratch.