Versioning in editable tables
Versioning in editable tables including receiving, by a table manager via a client computing system, an instruction to edit a first row in an editable table in a cloud-based data warehouse, wherein the instruction comprises a column value; determining, by the table manager, a version value for the edit to the first row; and generating, by the table manager, a database statement instructing the cloud-based data warehouse to create, in the editable table, a second row including the version value and the column value.
1. A method for versioning in editable tables, the method comprising:
receiving, by a table manager from a client computing system, an instruction to edit a first row in an editable table in a cloud-based data warehouse, wherein the instruction comprises an indication that a location of the first row within the editable table has changed, and wherein the first row in the editable table on the cloud-based data warehouse comprises a current sequence number and a current version value;
determining, by the table manager, an updated version value for the edit to the first row; and
generating, by the table manager, a database statement instructing the cloud-based data warehouse to create, in the editable table, a second row including the updated version value and an updated sequence value indicating the changed location of the first row in the editable table,
wherein the table manager is hosted by an intermediary computing system separate from the client computing system and the cloud-based data warehouse, and
wherein the cloud-based data warehouse creates the second row in response to receiving the database statement.
2. The method of claim 1 , further comprising: presenting, on the client computing system by the table manager, the editable table comprising the second row, wherein the first row is not presented.
3. The method of claim 1 , further comprising:
receiving, by the table manager from the client computing system, a request for a particular version of the editable table;
generating, by the table manager, a subsequent database statement to retrieve each row in the particular version of the editable table; and
presenting, by the table manager, query results of the subsequent database statement on the client computing system.
4. The method of claim 3 , wherein the database statement to retrieve each row in the particular version of the editable table selects, for each primary key value, a row with a highest version value that does not exceed the requested particular version of the editable table.
5. The method of claim 1 , wherein generating, by the table manager, the database statement comprises adding a version column to existing rows in the editable table by joining the editable table to a companion table comprising the version column.
6. The method of claim 1 , wherein the first row and the second row comprise a same primary key value indicating that the first row and the second row are different versions of a same row.
7. The method of claim 1 , wherein determining the updated version value for the edit to the first row comprises retrieving the updated version value from a version engine.
8. The method of claim 1 , wherein the updated version value for the second row is greater than the current version value for the first row.
9. The method of claim 1 , wherein the database statement is a structured query language statement.
10. An apparatus for versioning in 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 the steps of:
receiving, by a table manager from a client computing system, an instruction to edit a first row in an editable table in a cloud-based data warehouse, wherein the instruction comprises an indication that a location of the first row within the editable table has changed, and wherein the first row in the editable table on the cloud-based data warehouse comprises a current sequence number and a current version value;
determining, by the table manager, an updated version value for the edit to the first row; and
generating, by the table manager, a database statement instructing the cloud-based data warehouse to create, in the editable table, a second row including the version value and an updated sequence value indicating the changed location of the first row in the editable table,
wherein the table manager is hosted by an intermediary computing system separate from the client computing system and the cloud-based data warehouse, and
wherein the cloud-based data warehouse creates the second row in response to receiving the database statement.
11. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the step of: presenting, on the client computing system, the editable table comprising the second row, wherein the first row is not presented.
12. The apparatus of claim 10 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from the client computing system, a request for a particular version of the editable table;
generating a subsequent database statement to retrieve each row in the particular version of the editable table; and
presenting query results of the subsequent database statement on the client computing system.
13. The apparatus of claim 12 , wherein the database statement to retrieve each row in the particular version of the editable table selects, for each primary key value, a row with a highest version value that does not exceed the requested particular version of the editable table.
14. The apparatus of claim 10 , wherein generating the database statement comprises adding a version column to existing rows in the editable table by joining the editable table to a companion table comprising the version column.
15. The apparatus of claim 10 , wherein the first row and the second row comprise a same primary key value indicating that the first row and the second row are different versions of a same row.
16. The apparatus of claim 10 , wherein determining the updated version value for the edit to the first row comprises retrieving the updated version value from a version engine.
17. The apparatus of claim 10 , wherein the version value for the second row is greater than the current version value for the first row.
18. A computer program product for versioning in 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 the steps of:
receiving, by a table manager from a client computing system, an instruction to edit a first row in an editable table in a cloud-based data warehouse, wherein the instruction comprises an indication that a location of the first row within the editable table has changed, and wherein the first row in the editable table on the cloud-based data warehouse comprises a current sequence number and a current version value;
determining, by the table manager, an updated version value for the edit to the first row; and
generating, by the table manager, a database statement instructing the cloud-based data warehouse to create, in the editable table, a second row including the version value and an updated sequence value indicating the changed location of the first row in the editable table,
wherein the table manager is hosted by an intermediary computing system separate from the client computing system and the cloud-based data warehouse, and
wherein the cloud-based data warehouse creates the second row in response to receiving the database statement.