US 12,487,977 B2
Storage lifecycle control in a database system
Istvan Cseri, Seattle, WA (US); Mayank Gupta, Seattle, WA (US); Kishore Udayashankar Kasi, San Jose, CA (US); Sukruth Komarla Sukumar, Bellevue, WA (US); Polita Paulus, Kirkland, WA (US); and Saurin Shah, Kirkland, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jan. 4, 2024, as Appl. No. 18/403,892.
Prior Publication US 2025/0225110 A1, Jul. 10, 2025
Int. Cl. G06F 16/215 (2019.01); G06F 16/11 (2019.01); G06F 16/16 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 16/125 (2019.01); G06F 16/162 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to execute operations comprising:
receiving, from a first user having administrator privileges, input comprising a set of deletion criteria for a database system;
storing the set of deletion criteria in association with the database system;
causing presentation of the set of deletion criteria in a user interface to a second user having a role with access rights to the set of deletion criteria;
receiving, from the second user, a selection of an individual deletion criterion from the set of deletion criteria presented to the second user in the user interface;
applying the individual deletion criterion to a set of tables of the database system, the individual deletion criterion being associated with multiple tables of the database system in response to receiving the selection of the individual deletion criterion;
determining that an individual portion of the set of tables satisfies the individual deletion criterion; and
in response to determining that the individual portion of the set of tables satisfies the individual deletion criterion, transferring the individual portion of the set of tables to a temporary storage system.