How long is Snowpipe data load history retained?

The correct answer is C. 64 days. Snowpipe load history metadata is retained for 64 days. This is distinct from the standard COPY INTO load history, which is only retained for 14 days (making option D a common wrong answer). The 64-day retention allows Snowpipe to deduplicate file loads and prevent the same…

Data Loading and Unloading

Question

Options

AAs configured in the create pipe settings
BUntil the pipe is dropped
C64 days
D14 days

How the community answered

(16 responses)

A
6% (1)
B
6% (1)
C
88% (14)

Explanation

Snowpipe load history metadata is retained for 64 days. This is distinct from the standard COPY INTO load history, which is only retained for 14 days (making option D a common wrong answer). The 64-day retention allows Snowpipe to deduplicate file loads and prevent the same files from being ingested twice within that window. The retention period is fixed by Snowflake and cannot be configured in the CREATE PIPE statement, so option A is incorrect. The history is not dropped along with the pipe, so option B is also incorrect.

Topics

#Snowpipe#Data Loading#Retention Policy#Load History

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice