How many days is load history for Snowpipe retained?

The correct answer is C. 14 days. Snowpipe load history - the record of files ingested via Snowpipe - is retained for 14 days. This history is queryable via the INFORMATION_SCHEMA.LOAD_HISTORY view or the REST API endpoint. It is used to prevent duplicate file loads; Snowpipe tracks which files have already…

Data Loading and Unloading

Question

Options

A1 day
B7 days
C14 days
D64 days

How the community answered

(34 responses)

A
9% (3)
B
3% (1)
C
88% (30)

Explanation

Snowpipe load history - the record of files ingested via Snowpipe - is retained for 14 days. This history is queryable via the INFORMATION_SCHEMA.LOAD_HISTORY view or the REST API endpoint. It is used to prevent duplicate file loads; Snowpipe tracks which files have already been ingested within this 14-day window and will skip reloading them. After 14 days, the record is purged, so files older than 14 days could be reloaded if submitted again.

Topics

#Snowpipe#Load History#Data Retention#Continuous Data Loading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice