How can the Snowpipe REST API be used to keep a log of data load history?
How can the Snowpipe REST API be used to keep a log of data load history?
To keep a log of data load history using the Snowpipe REST API, it is recommended to use insertReport rather than loadHistoryScan in order to avoid exceeding the rate limit and potential API throttling. Calling insertReport every 8 minutes for a 10-minute time range ensures that the log remains up-to-date while also staying within recommended usage guidelines.
Answer should be C. "..To help avoid exceeding the rate limit (error code 429), we recommend relying more heavily on insertReport than loadHistoryScan.." https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis
C is correct - insertReport should be favored over loadHistory as excessive usage of the latter tends to lead to API throttling