Snowflake COF-R02 Question Answer
How long is Snowpipe data load history retained?
As configured in the create pipe settings
Until the pipe is dropped
64 days
14 days
Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20data%20load &text=Stored%20in%20the%20metadata%20of,statement%20as%20the%20statement%20output.&text=Stored%20in%20the%20metadata%20of%20the%20pipe%20for%2014%20days.
TESTED 02 Aug 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved