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, from a client computing system by a statement generator, a table update request to update a table within a database on a cloud-based data warehouse, including presenting, through a graphical user interface on the client computing system, a table visualization of the table, wherein the table update request comprises an update value and a selection of a row and a column from the table, wherein receiving the table update request includes detecting a user interaction indicating the selection of the row and the column from the table visualization, and wherein the statement generator is included within 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 specific to the table from the cloud-based data warehouse; and
sending, to the database on the cloud-based data warehouse by the statement generator based on the selection and in response to the verifying, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value.
2 . The method of claim 1 , further comprising:
determining that a user associated with the table update request is authorized to update the selection.
3 . The method of claim 1 , further comprising:
verifying, by the statement generator, that the update value is an acceptable type of value for the selected row and column of the table.
4 . The method of claim 1 , further comprising:
determining that the update value is one of a group of acceptable update values.
5 . 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 table update request to the cloud-based data warehouse.
6 . The method of claim 1 , wherein the table update request further comprises a request to add a new row to the database.
7 . The method of claim 1 , wherein the table update request further comprises an identifier of the table.
8 . The method of claim 1 , wherein the update database statement may be a structured query language (SQL) statement.
9 . 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, from a client computing system by a statement generator, a table update request to update a table within a database on a cloud-based data warehouse, including presenting, through a graphical user interface on the client computing system, a table visualization of the table, wherein the table update request comprises an update value and a selection of a row and a column from the table, wherein receiving the table update request includes detecting a user interaction indicating the selection of the row and the column from the table visualization, and wherein the statement generator is included within 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 specific to the table from the cloud-based data warehouse; and
sending, to the database on the cloud-based data warehouse by the statement generator based on the selection and in response to the verifying, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value.
10 . The apparatus of claim 9 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
determining that a user associated with the table update request is authorized to update the selection.
11 . The apparatus of claim 9 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
verifying, by the statement generator, that the update value is an acceptable type of value for the selected row and column of the table.
12 . The apparatus of claim 9 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
determining that the update value is one of a group of acceptable update values.
13 . The apparatus of claim 9 , 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 table update request to the cloud-based data warehouse.
14 . The apparatus of claim 9 , wherein the table update request further comprises a request to add a new row to the database.
15 . The apparatus of claim 9 , wherein the table update request further comprises an identifier of the table.
16 . 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, from a client computing system by a statement generator, a table update request to update a table within a database on a cloud-based data warehouse, including presenting, through a graphical user interface on the client computing system, a table visualization of the table, wherein the table update request comprises an update value and a selection of a row and a column from the table, wherein receiving the table update request includes detecting a user interaction indicating the selection of the row and the column from the table visualization, and wherein the statement generator is included within 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 specific to the table from the cloud-based data warehouse; and
sending, to the database on the cloud-based data warehouse by the statement
generator based on the selection and in response to the verifying, an update database
statement comprising a table identifier, a column identifier, a row identifier, and the update value.