US 12,130,795 B2
Streams using persistent tables
Tyler Arthur Akidau, Seattle, WA (US); Istvan Cseri, Seattle, WA (US); Tyler Jones, Redwood City, CA (US); and Daniel E. Sotolongo, Seattle, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jul. 26, 2023, as Appl. No. 18/359,322.
Application 18/359,322 is a continuation of application No. 17/648,622, filed on Jan. 21, 2022, granted, now 11,748,327.
Claims priority of provisional application 63/143,184, filed on Jan. 29, 2021.
Prior Publication US 2023/0367757 A1, Nov. 16, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/2282 (2019.01) [G06F 16/2358 (2019.01); G06F 16/24568 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method comprising:
storing a first table including a set of data in a network-based data system, the first table including a retention boundary for the set of data;
executing, by at least one hardware processor, modifications to the first table;
deleting data from the set of data in the first table past the retention boundary;
storing a second table including delta information related to the modifications executed past the retention boundary to the first table in a different format than the first table; and
generating change data capture information for the first table including a virtual table with one or more pointers to the second table for delta information related to modifications past the retention boundary and one or more pointers to the first table for data before the retention boundary.