Live editing editable tables
Live editing editable tables including receiving, via a client computing system by a table manager on an intermediary computing system, a request for an editable table stored on a cloud-based data warehouse; determining, by the table manager, that the requested editable table includes an uncommitted edit, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse; redirecting, by the table manager, the request for the editable table to an edit queue on the intermediary computing system, wherein the edit queue comprises the uncommitted edit; and servicing, by the table manager, the request for the editable table using the edit queue on the intermediary computing system.
1. A method for live editing editable tables, the method comprising:
receiving, via a client computing system by a table manager on an intermediary computing system, a request for an editable table stored on a cloud-based data warehouse;
determining, by the table manager, that an uncommitted edit to the editable table exists, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse at a time when the request was received;
in response to the determination, before servicing the request, first redirecting, by the table manager, the request for the editable table to an edit queue on the intermediary computing system instead of processing the request into a query for the cloud-based data warehouse, wherein the edit queue the uncommitted edit;
after the request is redirected, servicing by the table manager, the request for the editable table by combining the uncommitted edit from the edit queue from the intermediary computing system with the editable table from the cloud-based data warehouse; and
presenting, by the table manager, the editable table on the client computing system.
2. The method of claim 1 , wherein servicing the request for the editable table using the edit queue further comprises retrieving the editable table from a cache on the intermediary computing system.
3. The method of claim 1 , wherein servicing the request for the editable table using the edit queue further comprises retrieving the editable table from the cloud-based data warehouse.
4. The method of claim 3 , wherein retrieving the editable table from the cloud-based data warehouse comprises:
sending a database statement targeting the cloud-based data warehouse; and
receiving, from the cloud-based data warehouse, query results in response to the database statement, wherein the query results comprise the editable table.
5. The method of claim 4 , wherein the database statement is a structured query language statement.
6. The method of claim 1 , wherein servicing the request for the editable table using the edit queue comprises presenting the editable table with the uncommitted edit on the client computing system.
7. The method of claim 1 , wherein the uncommitted edit is held in the edit queue until a commitment acknowledgement for the uncommitted edit is received from the cloud-based data warehouse.
8. The method of claim 1 , wherein the request is received from a first user on a first client computing system, and wherein the uncommitted edit was received from a second user on a second client computing system.
9. The method of claim 1 , wherein the request for the editable table is a request for a portion of the editable table, and wherein determining, by the table manager, that the requested editable table includes the uncommitted edit comprises determining that the uncommitted edit is within the requested portion of the editable table.
10. An apparatus for live editing editable tables, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out:
receiving, via a client computing system by a table manager on an intermediary computing system, a request for an editable table stored on a cloud-based data warehouse;
determining, by the table manager, that an uncommitted edit to the editable table exists, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse at a time when the request was received;
in response to the determination, before servicing the request, first redirecting, by the table manager, the request for the editable table to an edit queue on the intermediary computing system instead of processing the request into a query for the cloud-based data warehouse, wherein the edit queue comprises the uncommitted edit;
after the request is redirected, servicing by the table manager, the request for the editable table by combining the uncommitted edit from the edit queue from the intermediary computing system with the editable table from the cloud-based data warehouse; and
presenting, by the table manager, the editable table on the client computing system.
11. The apparatus of claim 10 , wherein servicing the request for the editable table using the edit queue further comprises retrieving the editable table from a cache on the intermediary computing system.
12. The apparatus of claim 10 , wherein servicing the request for the editable table using the edit queue further comprises retrieving the editable table from the cloud-based data warehouse.
13. The apparatus of claim 12 , wherein retrieving the editable table from the cloud-based data warehouse comprises:
sending a database statement targeting the cloud-based data warehouse; and
receiving, from the cloud-based data warehouse, query results in response to the database statement, wherein the query results comprise the editable table.
14. The apparatus of claim 10 , wherein servicing the request for the editable table using the edit queue comprises presenting the editable table with the uncommitted edit on the client computing system.
15. The apparatus of claim 10 , wherein the uncommitted edit is held in the edit queue until a commitment acknowledgement for the uncommitted edit is received from the cloud-based data warehouse.
16. The apparatus of claim 10 , wherein the request is received from a first user on a first client computing system, and wherein the uncommitted edit was received from a second user on a second client computing system.
17. The apparatus of claim 10 , wherein the request for the editable table is a request for a portion of the editable table, and wherein determining, by the table manager, that the requested editable table includes the uncommitted edit comprises determining that the uncommitted edit is within the requested portion of the editable table.
18. A computer program product for live editing editable tables, the computer program product comprising a non-transitory computer readable storage medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out:
receiving, via a client computing system by a table manager on an intermediary computing system, a request for an editable table stored on a cloud-based data warehouse;
determining, by the table manager, that an uncommitted edit to the editable table exists, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse at a time when the request was received;
in response to the determination, before servicing the request, first redirecting, by the table manager, the request for the editable table to an edit queue on the intermediary computing system instead of processing the request into a query for the cloud-based data warehouse, wherein the edit queue comprises the uncommitted edit;
after the request is redirected, servicing by the table manager, the request for the editable table by combining the uncommitted edit from the edit queue from the intermediary computing system with the editable table from the cloud-based data warehouse; and
presenting, by the table manager, the editable table on the client computing system.