Explanation
COPY_HISTORY Record Indicates Unloaded Subset of Files:
If the COPY_HISTORY function output indicates a subset of files was not loaded, you may try to "refresh" the pipe.
This situation can arise in any of the following situations:
The external stage was previously used to bulk load data using the COPY INTO table command.
REST API:
o External event-driven functionality is used to call the REST APIs, and a backlog of data files al-ready existed in the external stage before the events were configured.
Auto-ingest:
o A backlog of data files already existed in the external stage before event notifications were con-figured.
o An event notification failure prevented a set of files from getting queued.
To load the data files in your external stage using the configured pipe, execute an ALTER PIPE ... REFRESH statement.