Audit logging for input tables on a data warehouse
Audit logging for input tables on a data warehouse including: receiving, by a workbook manager from a client computing system, a modification to an input table of a plurality of input tables stored in a cloud-based data warehouse; and storing, by the workbook manager, in an audit table stored in the cloud-based data warehouse, an entry describing the modification to the input table, wherein the audit table is configured to store entries describing modifications to any of the plurality of input tables.
1. A method for audit logging for input tables on a data warehouse, the method comprising:
receiving, by a workbook manager from a client computing system, a modification to an input table of a plurality of input tables stored in a cloud-based data warehouse; and
generating, by the workbook manager, a database statement targeting the cloud-based data warehouse to store, in an audit table stored in the cloud-based data warehouse, an entry describing the modification to the input table, wherein the audit table is configured to store entries describing modifications to any of the plurality of input tables.
2. The method of claim 1 , wherein the plurality of input tables corresponds to a same connection to the cloud-based data warehouse.
3. The method of claim 2 , wherein the same connection to the cloud-based data warehouse comprises a same set of credentials for the cloud-based data warehouse.
4. The method of claim 1 , wherein the plurality of input tables corresponds to a same logical entity.
5. The method of claim 1 , further comprising applying, by the workbook manager, the modification to the input table.
6. The method of claim 1 , wherein each of the input tables comprise a table created by the workbook manager and editable via a workbook.
7. The method of claim 1 , wherein the modification to the input table is received via a workbook on the client computing system.
8. The method of claim 7 , wherein the workbook presents the input table.
9. An apparatus for audit logging for input tables on a data warehouse, 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 workbook manager from a client computing system, a modification to an input table of a plurality of input tables stored in a cloud-based data warehouse; and
generating, by the workbook manager, a database statement targeting the cloud-based data warehouse to store, in an audit table stored in the cloud-based data warehouse, an entry describing the modification to the input table, wherein the audit table is configured to store entries describing modifications to any of the plurality of input tables.
10. The apparatus of claim 9 , wherein the plurality of input tables corresponds to a same connection to the cloud-based data warehouse.
11. The apparatus of claim 10 , wherein the same connection to the cloud-based data warehouse comprises a same set of credentials for the cloud-based data warehouse.
12. The apparatus of claim 9 , wherein the plurality of input tables corresponds to a same logical entity.
13. The apparatus of claim 9 , wherein the computer program instructions further cause the apparatus to carry out the step of applying, by the workbook manager, the modification to the input table.
14. The apparatus of claim 9 , wherein each of the input tables comprise a table created by the workbook manager and editable via a workbook.
15. The apparatus of claim 9 , wherein the modification to the input table is received via a workbook on the client computing system.
16. A computer program product for audit logging for input tables on a data warehouse, 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 workbook manager from a client computing system, a modification to an input table of a plurality of input tables stored in a cloud-based data warehouse; and
generating, by the workbook manager, a database statement targeting the cloud-based data warehouse to store, in an audit table stored in the cloud-based data warehouse, an entry describing the modification to the input table, wherein the audit table is configured to store entries describing modifications to any of the plurality of input tables.
17. The computer program product of claim 16 , wherein the plurality of input tables corresponds to a same connection to the cloud-based data warehouse.
18. The computer program product of claim 16 , wherein the same connection to the cloud-based data warehouse comprises a same set of credentials for the cloud-based data warehouse.