Load history
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.
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
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
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).
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
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
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
harshagc180
Highly Voted 1 year, 3 months agofahfouhi94
Highly Voted 1 year, 1 month agoPrasantSadangi
Most Recent 4 days agoAmitsnowflake
6 months, 2 weeks agosinghks
7 months, 2 weeks agoSA_206
1 year, 1 month agoBigDataBB
1 year, 2 months agosakis213
1 year, 3 months agoSV1122
1 year, 3 months agoSV1122
1 year, 3 months agoNaveen90
1 year, 3 months agohalol
1 year, 3 months agoDef21
9 months, 3 weeks ago