Snowflake SnowPro Certification Practice Test

How long does a Snowpipe store metadata?

1. 7 days

2. 14 days

3. 30 days

4. Indefinitely

The correct answer is: 14 days

Snowpipe stores metadata for a duration of 14 days. This metadata includes information about the data files that have been loaded through Snowpipe, capturing details such as file names, the time of ingestion, and other operational metrics. The 14-day retention period allows for sufficient time to track and manage the loading process, as well as to address any issues that may arise during that time. After this period, the metadata is automatically purged, which helps to manage storage costs and system performance. It's important to understand this timeframe, as it impacts how you can reprocess or monitor file ingestion activities. Retaining metadata for an extended period is not feasible, as it could lead to unnecessary accumulation of data and potential performance degradation. Therefore, knowing this retention policy is crucial for effective management and troubleshooting of Snowpipe operations.