COPY_HISTORY for Snowpipe loads includes which of the following?

• A. True; it includes only completed COPY INTO commands (even if runtime errors occurred)
• B. True; it includes all COPY INTO commands regardless of completion
• C. False; it includes only failed commands
• D. False; it includes none

Answer: (A)

COPY_HISTORY for Snowpipe loads shows finished COPY INTO commands that Snowpipe executes when pulling data from a stage. A command is considered finished once the load process completes, even if some rows or files produced runtime errors. Those completed attempts appear in COPY_HISTORY with details like the file name, rows loaded, and errors encountered. It does not include commands that never completed due to a fatal failure or cancellation, and it does include both successful completions and those that finished with data issues. So the statement that it includes only completed COPY INTO commands (even if runtime errors occurred) is the correct one.