page158
141
Figure 4-18.
Sample table time travel storage
After both
data_retention_time_in_days
and latency have elapsed, Figure 4-19
shows the expected result where the
failsafe_GB
value has changed.
Figure 4-19.
Sample table fail-safe storage
After seven days, your micro-partitions are removed. Figure 4-20 shows the expected
result where
failsafe_GB
value has changed back to zero.
Figure 4-20.
Sample table micro-partition removal
A similar sequence can be derived for cloned tables with updates.
Micro-partition Pitfalls
With Snowflake, the ability to clone and recover objects “at will” brings unforeseen
challenges when managing your accounts.
•
Developers and operations support staff forget to clean up temporary
objects created during production releases and maintenance
activities.
•
Stages also consume storage.
•
Internal stages should be monitored for use and periodically
removed where possible.
•
External stages consume CSP storage and likewise require
periodic cleanup.
ChaPTer 4
MiCro-ParTiTionS