How can the Snowpipe REST API be used to keep a log of data load history?

Question

Options

• ACall insertReport every 20 minutes, fetching the last 10,000 entries.
• BCall loadHistoryScan every minute for the maximum time range.
• CCall insertReport every 8 minutes for a 10-minute time range.
• DCall loadHistoryScan every 10 minutes for a 15-minute time range.

• A
  3% (1)
• B
  6% (2)
• D
  92% (33)

Explanation

The Snowpipe REST API offers two key endpoints for history: insertReport (returns load status for files submitted in the last 10 minutes) and loadHistoryScan (returns load history for a specified time range). To maintain a continuous, gap-free log, you must poll frequently enough and with a window large enough to overlap previous calls. Calling loadHistoryScan every 10 minutes with a 15-minute time range ensures a 5-minute overlap, guaranteeing no entries are missed between polls. Option C (every 8 minutes, 10-minute range) creates a 2-minute gap. Option A (insertReport every 20 minutes) misses 10 minutes of entries per cycle. Option B ('maximum time range every minute') is not a valid or efficient approach.

No community discussion yet for this question.