page150
133
Fail-Safe
Fail-Safe is an immutable seven-day period where micro-partitions on a best-effort basis
are retained for recovery with the assistance of Snowflake Support. Fail-Safe is a last-
resort; data is not accessible by any users.
Having dropped the test table in the previous section, you must wait until the
dropped micro-partitions transition through Time Travel into Fail-Safe. Note the Data
Retention Period for
lineitem_baseline_tt_test
was declared to be one day. You can
repeat the earlier query to check the storage:
SELECT active_GB,
time_travel_GB,
failsafe_GB,
retained_for_clone_GB
FROM v_table_storage_metrics
WHERE path_to_object
= 'TPC.TPC_OWNER.LINEITEM_BASELINE_TT_TEST';
Figure 4-11 shows your micro-partitions have transitioned to Fail-Safe.
The first row is your original image from Figure 4-10.
•
The second row is the new Fail-Safe data.
Figure 4-11.
Fail-safe storage consumption
You expect
failsafe_GB
to be the same as the original
active_GB
as Figure 4-11
demonstrates.
To recover data retained within Fail-Safe or raise a support ticket, see
https://
community.snowflake.com/s/article/How-To-Submit-a-Support-Case-in-
Snowflake-Lodge
.
You can find more information on Fail-Safe at
https://docs.snowflake.com/en/
user-guide/data-failsafe
and at
https://docs.snowflake.com/en/user-guide/
data-cdp-storage-costs
.
ChaPTer 4
MiCro-ParTiTionS