Question

A data engineer runs COPY INTO on a table from an internal named stage that already contains 50 files. The load completes successfully. Later that day, the same 50 files plus 10 new files are present in the stage, and the engineer reruns the identical COPY INTO command without any options that alter default behavior. What happens?

Accepted Answer

Only the 10 new files are loaded because COPY INTO uses load metadata to skip files already loaded within the last 64 days.

Answer

All 60 files are reloaded because COPY INTO always processes every file present in the stage.

Answer

The command fails with a duplicate-file error until the previously loaded files are purged from the stage.

Answer

None of the files are loaded because the target table already contains data from the first COPY operation.