Remote storage of sensitive data for editable tables
Remote storage of sensitive data for editable tables including receiving, via a client computing system, an instruction to add client data to an editable table in a cloud-based data warehouse, wherein the instruction comprises the client data and a table edit to the editable table; sending the client data to a client data log on the cloud-based data warehouse; storing, in an edit queue on an intermediary computing system, the table edit with a reference to the client data in the client data log on the cloud-based data warehouse; and generating a database statement to add the client data to the editable table in the cloud-based data warehouse, wherein the database statement lacks the client data and comprises the reference to the client data in the client data log on the cloud-based data warehouse.
1. A method for remote storage of sensitive data for editable tables, the method comprising:
receiving, by a table manager on an intermediary computing system from a client computing system, an instruction to add client data to an editable table in a cloud-based data warehouse, wherein the instruction comprises the client data and a table edit to the editable table, wherein the intermediary computing system comprising the table manager is separate from the cloud-based data warehouse;
sending, by the table manager, the client data to a client data log on the cloud-based data warehouse;
storing, by the table manager in an edit queue on the intermediary computing system, the table edit with a reference to the client data in the client data log on the cloud-based data warehouse; and
generating, by the table manager on the intermediary computing system, a database statement to add the client data to the editable table in the cloud-based data warehouse, wherein the database statement lacks the client data and comprises the reference to the client data in the client data log on the cloud-based data warehouse.
2. The method of claim 1 , wherein sending the client data to the client data log on the cloud-based data warehouse comprises storing the table edit with the client data in the client data log on the cloud-based data warehouse.
3. The method of claim 1 , further comprising:
in response to detecting that the edit queue on the intermediary computing system is unavailable:
retrieving the client data log from the cloud-based data warehouse; and
adding edits stored in the client data log to the edit queue.
4. The method of claim 1 , wherein sending the client data to the client data log on the cloud-based data warehouse comprises removing the client data from the intermediary computing system.
5. The method of claim 1 , wherein sending the client data to the client data log on the cloud-based data warehouse comprises issuing a database statement to store the client data in the client data log on the cloud-based data warehouse.
6. The method of claim 1 , wherein the client data is not stored in the edit queue.
7. The method of claim 1 , wherein the table edit is held in the edit queue until a commitment acknowledgement for the table edit is received from the cloud-based data warehouse.
8. The method of claim 1 , wherein the client data comprises personal protected information.
9. The method of claim 1 , wherein the client data log is a table on the cloud-based data warehouse.
10. The method of claim 1 , wherein the database statement is a structured query language statement.
11. An apparatus for remote storage of sensitive data for 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 on an intermediary computing system from a client computing system, an instruction to add client data to an editable table in a cloud-based data warehouse, wherein the instruction comprises the client data and a table edit to the editable table;
sending, by the table manager, the client data to a client data log on the cloud-based data warehouse;
storing, by the table manager in an edit queue on the intermediary computing system separate from the cloud-based data warehouse, the table edit with a reference to the client data in the client data log on the cloud-based data warehouse; and
generating, by the table manager on the intermediary computing system, a database statement to add the client data to the editable table in the cloud-based data warehouse, wherein the database statement lacks the client data and comprises the reference to the client data in the client data log on the cloud-based data warehouse.
12. The apparatus of claim 11 , wherein sending the client data to the client data log on the cloud-based data warehouse comprises storing the table edit with the client data in the client data log on the cloud-based data warehouse.
13. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
in response to detecting that the edit queue on the intermediary computing system is unavailable:
retrieving the client data log from the cloud-based data warehouse; and
adding edits stored in the client data log to the edit queue.
14. The apparatus of claim 11 , wherein sending the client data to the client data log on the cloud-based data warehouse comprises removing the client data from the intermediary computing system.
15. The apparatus of claim 11 , wherein sending the client data to the client data log on the cloud-based data warehouse comprises issuing a database statement to store the client data in the client data log on the cloud-based data warehouse.
16. The apparatus of claim 11 , wherein the client data is not stored in the edit queue.
17. The apparatus of claim 11 , wherein the table edit is held in the edit queue until a commitment acknowledgement for the table edit is received from the cloud-based data warehouse.
18. The apparatus of claim 11 , wherein the client data comprises personal protected information.
19. The apparatus of claim 11 , wherein the client data log is a table on the cloud-based data warehouse.
20. A computer program product for remote storage of sensitive data for editable tables, the computer program product disposed upon a computer readable 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 on an intermediary computing system from a client computing system, an instruction to add client data to an editable table in a cloud-based data warehouse, wherein the instruction comprises the client data and a table edit to the editable table;
sending, by the table manager, the client data to a client data log on the cloud-based data warehouse;
storing, by the table manager in an edit queue on the intermediary computing system separate from the cloud-based data warehouse, the table edit with a reference to the client data in the client data log on the cloud-based data warehouse; and
generating, by the table manager on the intermediary computing system, a database statement to add the client data to the editable table in the cloud-based data warehouse, wherein the database statement lacks the client data and comprises the reference to the client data in the client data log on the cloud-based data warehouse.