Database XYZ has the data_retention_time_in_days parameter set to 7 days and table xyz.public.ABC has the data_retention_time_in_days set to 10 days.
A Developer accidentally dropped the database containing this single table 8 days ago and just discovered the mistake.
How can the table be recovered?
undrop database xyz;
create -able abc_restore as select * from xyz.public.abc at {offset = > -60*60*24*8};
create table abc_restore clone xyz.public.abc at (offset = > -3€0G*24*3);
Create a Snowflake Support case lo restore the database and tab e from "a i-safe