How many days is load history for Snowpipe retained?
How many days is load history for Snowpipe retained?
Load history for Snowpipe is retained for 14 days. This history is stored in the metadata of the pipe object and includes information such as the date and time of the load, the number of files loaded, and the size of the data loaded.
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. Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view. source : https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro
COPY INTO - Stored in the metadata of the target table for 64 days SNOWPIPE - Stored in the metadata of the pipe for 14 days
https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html
C https://docs.snowflake.com/en/sql-reference/functions/copy_history.html
C. 14 days
Correct ans 14 days
Correct
Load history for Snowpipe is retained for 14 days:C Snowflake stores load history for Snowpipe in the metadata of the pipe object. This history includes information such as the date and time of the load, the number of files loaded, and the size of the data loaded. SELECT * FROM INFORMATION_SCHEMA.PIPE_LOAD_HISTORY WHERE PIPE_NAME = '<pipe_name>' ORDER BY START_TIME DESC;
C.14 days