Generating edited input tables for low-latency presentation
Generating edited input tables for low-latency presentation including receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems; generating, by the workbook manager, a database statement comprising an uncommitted edit, wherein the database statement configured to retrieve the input table from the cloud-based data warehouse and combine the input table with the uncommitted edit; and providing, by the workbook manager, the input table comprising the uncommitted edit to the first workbook client on the first client computing system.
1 . A method comprising:
receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems;
generating, by the workbook manager, a database statement comprising an uncommitted edit, wherein the database statement is configured to retrieve the input table from the cloud-based data warehouse and combine the input table with the uncommitted edit; and
providing, by the workbook manager, the input table comprising the uncommitted edit to the first workbook client on the first client computing system.
2 . The method of claim 1 , further comprising:
receiving, from a second workbook client on a second client computing system, an input table edit targeting the input table on the cloud-based data warehouse; and
storing the input table edit in a cache as the uncommitted edit.
3 . The method of claim 2 , further comprising instructing the cloud-based data warehouse to apply the input table edit to the input table.
4 . The method of claim 1 , further comprising:
receiving, from the cloud-based data warehouse, an acknowledgement that the uncommitted edit has been committed to the input table; and
removing the uncommitted edit from a cache.
5 . The method of claim 1 , further comprising retrieving, using the database statement, query results comprising the input table and uncommitted edit.
6 . The method of claim 1 , wherein generating the database statement comprising the uncommitted edit comprises compiling the database statement using the request for the input table.
7 . The method of claim 1 , wherein generating the database statement comprising the uncommitted edit comprises generating a portion of the database statement that edits the input table according to the uncommitted edit.
8 . The method of claim 1 , wherein the request for the input table is a request for a portion of the input table, and wherein generating the database statement comprising the uncommitted edit comprises determining that the uncommitted edit is within the requested portion of the input table.
9 . The method of claim 1 , wherein the intermediary computing system is between the first client computing system and the cloud-based data warehouse.
10 . The method of claim 1 , wherein the database statement is a structured query language statement.
11 . A system comprising:
a memory; and
a processing device, operatively coupled to the memory, the processing device configured to:
receive, on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems;
generate a database statement comprising an uncommitted edit, wherein the database statement is configured to retrieve the input table from the cloud-based data warehouse and combine the input table with the uncommitted edit; and
provide the input table comprising the uncommitted edit to the first workbook client on the first client computing system.
12 . The system of claim 11 , wherein the processing device is further configured to:
receive, from a second workbook client on a second client computing system, an input table edit targeting the input table on the cloud-based data warehouse; and
store the input table edit in a cache as the uncommitted edit.
13 . The system of claim 12 , wherein the processing device is further configured to instruct the cloud-based data warehouse to apply the input table edit to the input table.
14 . The system of claim 11 , wherein the processing device is further configured to:
receive, from the cloud-based data warehouse, an acknowledgement that the uncommitted edit has been committed to the input table; and
remove the uncommitted edit from a cache.
15 . The system of claim 11 , wherein the processing device is further configured to retrieve, using the database statement, query results comprising the input table and uncommitted edit.
16 . The system of claim 11 , wherein generating the database statement comprising the uncommitted edit comprises compiling the database statement using the request for the input table.
17 . The system of claim 11 , wherein generating the database statement comprising the uncommitted edit comprises generating a portion of the database statement that edits the input table according to the uncommitted edit.
18 . The system of claim 11 , wherein the request for the input table is a request for a portion of the input table, and wherein generating the database statement comprising the uncommitted edit comprises determining that the uncommitted edit is within the requested portion of the input table.
19 . The system of claim 11 , wherein the intermediary computing system is between the first client computing system and the cloud-based data warehouse.
20 . A non-transitory computer readable storage medium storing instructions which, when executed, cause a processing device to:
receive, on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems;
generate a database statement comprising an uncommitted edit, wherein the database statement is configured to retrieve the input table from the cloud-based data warehouse and combine the input table with the uncommitted edit; and
provide the input table comprising the uncommitted edit to the first workbook client on the first client computing system.