US 12,436,942 B2
Editing and updating database tables on a cloud-based data warehouse
Max H. Seiden, San Francisco, CA (US); Rodolphe Gagneron, San Diego, CA (US); and Gregory G. Owen, San Mateo, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Feb. 22, 2022, as Appl. No. 17/677,968.
Claims priority of provisional application 63/278,356, filed on Nov. 11, 2021.
Prior Publication US 2023/0147197 A1, May 11, 2023
Int. Cl. G06F 16/23 (2019.01); G06F 16/22 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 16/2282 (2019.01); G06F 16/283 (2019.01)] 14 Claims
OG exemplary drawing
 
1. A method for editing and updating database tables on a cloud-based data warehouse, the method comprising:
receiving by a table manager on an intermediary computing system, a request to present a database table on a client computing system;
retrieving, by the table manager from the cloud-based data warehouse, query results comprising a base table merged with a modifications table;
presenting, by the table manager on the client computing system, the query results as the database table comprising the base table merged with the modifications table;
receiving, by the table manager from the client computing system, an instruction to edit the database table on the cloud-based data warehouse, wherein the instruction comprises a table edit targeting the database table;
locating, by the table manager, the modifications table on the cloud-based data warehouse associated with the database table, including accessing a data structure mapping the database table to the modifications table; and
servicing the instruction to edit the database table by generating a database statement targeting the cloud-based data warehouse to apply the table edit to the modifications table associated with the database table, wherein the database statement targeting the cloud-based data warehouse is generated by the intermediary computing system.