Why might COPY_HISTORY not include some files loaded via Snowpipe?

• A. Some of the COPY INTO operations aborted and could never be completed
• B. Copy_HISTORY does not capture any files that errored out
• C. Copy_HISTORY does not capture file copy history through Snowpipe
• D. COPY_HISTORY includes all COPY INTO commands regardless of completion

Answer: (A)

COPY_HISTORY only logs COPY INTO operations that complete successfully. When Snowpipe attempts to load a file but the copy process is aborted or cannot be completed, that specific load never finishes, so there’s no completed COPY INTO entry to record. In other words, a file loaded via Snowpipe might not appear in COPY_HISTORY if its load was started but never completed. The history does reflect completed copies, including those driven by Snowpipe, but it does not include attempts that fail to finish.