Snowpipe retains load history metadata for 14 days, as specified in Snowflake documentation. This duration allows users to monitor recent data loading activities and troubleshoot any issues while maintaining efficient metadata management. The community discussion shows 100% consensus on option C with upvoted comments confirming this is correct, and no alternative durations (2 days, 7 days, or 64 days) are supported by Snowflake's official documentation or community knowledge.