US 11,928,098 B2
Table data processing using a change tracking column
Subramanian Muralidhar, Mercer Island, WA (US); Istvan Cseri, Seattle, WA (US); Torsten Grabs, San Mateo, CA (US); and Benoit Dageville, San Mateo, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jun. 27, 2022, as Appl. No. 17/809,203.
Application 17/809,203 is a continuation of application No. 17/653,527, filed on Mar. 4, 2022, granted, now 11,397,720.
Application 17/653,527 is a continuation of application No. 17/491,106, filed on Sep. 30, 2021, granted, now 11,294,882.
Application 17/491,106 is a continuation of application No. 17/364,562, filed on Jun. 30, 2021, granted, now 11,169,983.
Application 17/364,562 is a continuation of application No. 16/213,554, filed on Dec. 7, 2018, granted, now 11,086,840.
Prior Publication US 2022/0327107 A1, Oct. 13, 2022
Int. Cl. G06F 16/23 (2019.01); G06F 16/18 (2019.01); G06F 16/245 (2019.01); G06F 16/27 (2019.01); G06F 9/46 (2006.01)
CPC G06F 16/2358 (2019.01) [G06F 16/1865 (2019.01); G06F 16/2322 (2019.01); G06F 16/2365 (2019.01); G06F 16/245 (2019.01); G06F 16/278 (2019.01); G06F 9/466 (2013.01)] 30 Claims
OG exemplary drawing
 
1. A method comprising:
detecting, by at least one hardware processor, a first executed transaction causing a first modification to table data stored in a table, the table data associated with a corresponding metadata file with metadata information of the table;
generating a new metadata file responsive to the first executed transaction, the new metadata file being distinct from the metadata file, and the new metadata file including the metadata information and additional metadata associated with the first modification;
detecting a second executed transaction causing a second modification to the table data; and
updating the table data with a change tracking column, the change tracking column including lineage of executed transactions on the table data, the lineage indicating at least the first transaction and the second transaction, timestamps when the first and second transactions were executed, identification information of at least one user account initiating the first and second transactions.