The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
The bulk data load history that is available upon completion of the COPY statement is stored in the metadata of the target table for 64 days. This data is crucial for tracking the load status of staged data files and preventing data duplication. The 64-day retention period ensures that the load metadata is available for sufficient time to manage and verify data loads effectively.
Correct Answer : C https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#load-history
data bulk load history ===> in the metadata of the target table for 64 days snowpipe ====> in the metadata of the pipe for 14 days
For Snowpipe use copy_history. and for table LOAD_History, both have 14day hisotry https://docs.snowflake.com/en/sql-reference/functions/copy_history.html https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html
A CORRET : https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html
This refers to Information schema view. A talks about "metadata of the target table" so this is not correct. The information in target table metadata is retained for 64 days https://docs.snowflake.com/en/user-guide/data-load-considerations-load#load-metadata So, C is correct
It is C
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#load-history
Sorry the answer is C.
I think, since it is Bulk loading. Answer is A
1. The load history for Snowpipe operations is stored in the metadata of the pipe object , it remains for 14 days. When a pipe is recreatedthe load history is dropped
Load history is stored in the metadata of the target table for 64 days
https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#load-metadata Snowflake maintains detailed metadata for each table into which data is loaded .... This load metadata expires after 64 days. If the LAST_MODIFIED date for a staged data file is less than or equal to 64 days, the COPY command can determine its load status for a given table and prevent reloading (and data duplication).