Explanation:
COPY INTO is idempotent. It tracks files already loaded and skips them on subsequent executions, preventing duplicate ingestion. FILES is optional, Parquet is supported, and successfully committed Delta changes are immediately visible without a manual refresh.
A daily COPY INTO statement loads the previous day’s sales files from /transactions/raw into transactions, but the row count does not increase. What is a likely explanation?
A
The file format was not included with FORMAT_OPTIONS.
B
The file names were not included with the FILES keyword.
C
The previous day’s file has already been copied into the table.
D
Parquet does not support COPY INTO.
E
The table must be refreshed before copied rows are visible.
No comments yet.