Database writeback using an intermediary statement generator
Database writeback using an intermediary statement generator including receiving, by a statement generator, a table update request to update a table within a database on a cloud-based data warehouse, wherein the table update request comprises an update value and a selection of a row and a column from the table; verifying, by the statement generator, that the selection is updatable; generating, by the statement generator based on the selection and in response to the verification, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value; and sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse, wherein the table of the database is updated in response to receiving the update database statement.
1. A method of database writeback using an intermediary statement generator, the method comprising:
receiving, by the statement generator included within a statement generator computing system from a client computing system, a table update request to update a table within a database on a cloud-based data warehouse, wherein the table update request comprises an update value and a selection of a row and a column from the table, wherein the statement generator computing system is an intermediary computing system between the client computing system and the cloud-based data warehouse;
verifying, by the statement generator, that the selection is updatable, including retrieving permission information about the table from the cloud-based data warehouse;
generating, by the statement generator based on the selection and in response to the verification, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value, including compiling the update database statement from a state specification of the graphical user interface on the client computing system; and
sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse, wherein the table of the database is updated in response to receiving the update database statement.
2. The method of claim 1 , wherein receiving the table update request comprises:
presenting, through a graphical user interface on the client computing system, a table visualization of the table from the database on the cloud-based data warehouse; and
detecting a user interaction indicating the selection of the row and the column from the table visualization.
3. The method of claim 1 , wherein verifying that the selection is updatable comprises determining that a user associated with the update request is authorized to update the selection.
4. The method of claim 1 , wherein verifying that the selection is updatable comprises determining that the update value is an acceptable type of value.
5. The method of claim 1 , wherein verifying that the selection is updatable comprises determining that the update value is one of a group of acceptable update values.
6. The method of claim 1 , wherein sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse comprises passing credentials for a user associated with the update request to the cloud-based data warehouse.
7. The method of claim 1 , the table update request further comprises a request to add a new row to the database.
8. An apparatus for database writeback using an intermediary statement generator, 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 the statement generator included within a statement generator computing system from a client computing system, a table update request to update a table within a database on a cloud-based data warehouse, wherein the table update request comprises an update value and a selection of a row and a column from the table, wherein the statement generator computing system is an intermediary computing system between the client computing system and the cloud-based data warehouse;
verifying, by the statement generator, that the selection is updatable, including retrieving permission information about the table from the cloud-based data warehouse;
generating, by the statement generator based on the selection and in response to the verification, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value, including compiling the update database statement from a state specification of the graphical user interface on the client computing system; and
sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse, wherein the table of the database is updated in response to receiving the update database statement.
9. The apparatus of claim 8 , wherein receiving the table update request comprises:
presenting, through a graphical user interface on the client computing system, a table visualization of the table from the database on the cloud-based data warehouse; and
detecting a user interaction indicating the selection of the row and the column from the table visualization.
10. The apparatus of claim 8 , wherein verifying that the selection is updatable comprises determining that a user associated with the update request is authorized to update the selection.
11. The apparatus of claim 8 , wherein verifying that the selection is updatable comprises determining that the update value is an acceptable type of value.
12. The apparatus of claim 8 , wherein verifying that the selection is updatable comprises determining that the update value is one of a group of acceptable update values.
13. The apparatus of claim 8 , wherein sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse comprises passing credentials for a user associated with the update request to the cloud-based data warehouse.
14. A computer program product for database writeback using an intermediary statement generator, the computer program product disposed upon a non-transitory 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 the statement generator included within a statement generator computing system from a client computing system, a table update request to update a table within a database on a cloud-based data warehouse, wherein the table update request comprises an update value and a selection of a row and a column from the table, wherein the statement generator computing system is an intermediary computing system between the client computing system and the cloud-based data warehouse;
verifying, by the statement generator, that the selection is updatable, including retrieving permission information about the table from the cloud-based data warehouse;
generating, by the statement generator based on the selection and in response to the verification, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value, including compiling the update database statement from a state specification of the graphical user interface on the client computing system; and
sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse, wherein the table of the database is updated in response to receiving the update database statement.