US 12,259,898 B1
Transient exploratory editing of input tables on a data warehouse
Gregory G. Owen, San Mateo, CA (US); and Stipo Josipovic, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Mar. 23, 2023, as Appl. No. 18/189,030.
Int. Cl. G06F 16/00 (2019.01); G06F 16/248 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01); G06F 40/18 (2020.01)
CPC G06F 16/252 (2019.01) [G06F 16/248 (2019.01); G06F 16/283 (2019.01); G06F 40/18 (2020.01)] 20 Claims
OG exemplary drawing
 
1. A method for transient exploratory editing of input tables on a data warehouse, the method comprising:
presenting, on a client computing system by a workbook manager, an input table in a cloud-based data warehouse, wherein the input table is presented in an exploration mode that displays edits to the input table without altering the input table in the cloud-based data warehouse;
receiving, by the workbook manager, a change to the input table;
modifying, by the workbook manager, a presentation of the input table reflecting the change without modifying the input table in the cloud-based data warehouse, wherein the modification is applied to a temporary instance of the input table stored locally to the workbook manager;
querying, periodically by the workbook manager, the cloud-based data warehouse for updates to the input table; and
applying, by the workbook manager, detected updates to the input table, wherein the detect updates are presented in the presentation of the input table reflecting the change received in the exploration mode, and wherein the detected updates are made to the input table stored locally to the workbook manager.