Which SnowPipe REST endpoint fetches a report of ingested files whose contents were recently added to a table?

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

Answer: (C)

SnowPipe REST endpoints that deal with ingestion results are designed to give you feedback on what was just ingested. When you want a summary of the files whose contents were recently added to the target table, you use the endpoint that returns a report for those inserted files. That endpoint is insertReport, which provides details about the files you just uploaded and confirms whether their contents were loaded into the table.

Other endpoints serve different purposes: insertFiles is for sending files to the stage to be ingested, not for reporting results; loadHistoryScan looks at historical load activity rather than the immediate insertion; getReport retrieves an existing report, which may not reflect the most recent ingestion.