Which SnowPipe REST endpoint fetches a history between two points in time?

• A. insertFiles
• B. loadHistoryScan
• C. insertReport
• D. getHistory

Answer: (B)

To fetch a history between two points in time, you use a time-bounded history query endpoint. The loadHistoryScan endpoint is designed to query SnowPipe’s load history within a specified time window, returning events that occurred between the start and end timestamps. This makes it the best fit for retrieving a history slice because you can define the exact window you’re interested in and get back the corresponding load events, statuses, and details.

The other options serve different purposes: insertFiles is for uploading files into a pipe for processing, insertReport is for submitting a report, and getHistory typically implies retrieving history but not necessarily with a built-in time window specified for scanning.