What does the insertReport Snowpipe endpoint do?

• A. Insert reports into a table
• B. Insert files into a table
• C. Retrieves a report of files submitted via insertFiles whose contents were recently ingested into a table.
• D. None of the above

Answer: (C)

You use the insertReport endpoint to pull back a summary of what Snowpipe has done after you submitted files with insertFiles. When you push files to a stage via insertFiles, Snowpipe processes them and loads their contents into the target table. The insertReport call returns a report that lists the files you submitted and shows which ones were successfully ingested into the table (and any issues if they weren’t), giving you a way to verify and reconcile the loading results. This is the core idea: it’s not about inserting data into a table directly, but about retrieving a record of what was ingested from the files you submitted.