Which REST endpoint does Snowpipe API provide for uploading data?

• A. InsertFiles
• B. InsertReport
• C. LoadHistoryScan
• D. LoadFiles

Answer: (A)

The key idea is that Snowpipe ingestion starts by uploading your data files to a stage so the pipe can process them. The REST API endpoint intended for this upload is InsertFiles. It’s specifically designed to push files into the stage, triggering Snowpipe ingestion according to your pipe’s configuration. The other endpoints serve different purposes—InsertReport is about reporting on an insert operation, LoadHistoryScan fetches historical load data, and LoadFiles relates to loading operations in a different context, not the upload mechanism for Snowpipe. So InsertFiles is the correct choice because it is the one you use to upload data for Snowpipe to ingest.