Answer-first summary for fast verification
Answer: In the metadata of the target table for 64 days
The question specifically asks about bulk data load history available upon completion of the COPY statement. According to Snowflake documentation and the community discussion consensus (with comment #740344 receiving 22 upvotes and multiple others confirming), bulk data load history is stored in the metadata of the target table for 64 days. This allows the COPY command to determine load status and prevent data duplication when LAST_MODIFIED date is within 64 days. Option A is incorrect because it specifies only 14 days retention. Options B and D are incorrect because they reference pipe metadata, which applies to Snowpipe (14 days retention) rather than bulk COPY operations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Where is the bulk data load history stored and for how long is it retained after a COPY statement completes?
A
In the metadata of the target table for 14 days
B
In the metadata of the pipe for 14 days
C
In the metadata of the target table for 64 days
D
In the metadata of the pipe for 64 days
No comments yet.