Recover deleted records from Snowflake if you don't remember the exact time / date

user_14444816 0
Viewed 567

I'm trying to recover some records but I don't remember the exact time or date they were deleted:

I remember that these records that were deleted all had 'nan' values in link and name columns, and the asof_date values were between July & October.

I believe they were deleted 1 day ago so I tried this (since 1440 min in a day) but nothing populates:

select * from my_table at(offset => -60*1440) 
where link = 'nan'
and name = 'nan'
and to_date(asof_date) >= '2021-07-01'
and to_date(asof_date) <= '2021-10-13'
snowflake-cloud-data-platform
1 Answers

Unfortunately, since your data retention period is only 1 day, you will not be able to make use of time travel or fail safe.

For future reference, provided that you have Enterprise edition or above, then you can set the retention period to be up to 90 days, and then you have 7 days fail-safe protection after that.

Understanding & Using Time Travel

user_10098230
Related