Creating data warehouse views for input tables
Creating data warehouse views for input tables including: selecting, by a workbook manager, a subset of columns of an input table stored in a cloud-based data warehouse, wherein the subset of columns excludes one or more metadata columns of the input table; generating, by the workbook manager, a view of the input table based on the subset of columns; and storing, by the workbook manager, the view of the input table in the cloud-based data warehouse.
1 . A method for creating data warehouse views for input tables, the method comprising:
creating, by a workbook manager, an input table on a cloud-based data warehouse in response to receiving a request, from a client computing system, to create the input table, wherein the input table is created with metadata columns that are not presented on the client computing system, wherein the workbook manager is included within an intermediary computing system between the client computing system and the cloud-based data warehouse;
presenting, by the workbook manager, the input table via a spreadsheet structure within a workbook, wherein the spreadsheet structure within the workbook enables a user of the client computing system to view and edit the input table;
selecting, by the workbook manager, a subset of columns of the input table stored in the cloud-based data warehouse, wherein the subset of columns excludes one or more of the metadata columns of the input table;
generating, by the workbook manager, a view of the input table based on the subset of columns; and
storing, by the workbook manager, the view of the input table in the cloud-based data warehouse accessible by a software application external to the workbook manager, wherein the one or more of the metadata columns are inaccessible by the software application via the view of the input table.
2 . The method of claim 1 , wherein the subset of columns corresponds to a presentation of the input table in the workbook.
3 . The method of claim 1 , further comprising receiving, by the workbook manager, a request from the client computing system to generate the view of the input table.
4 . The method of claim 1 , further comprising:
receiving, from the client computing system, a modification to the input table; and
updating the view of the input table based on the modification.
5 . The method of claim 4 , wherein the modification is received via the workbook presenting the input table.
6 . The method of claim 1 , wherein the one or more of the metadata columns comprise one or more metadata columns generated during creation of the input table.
7 . An apparatus for creating data warehouse views for input 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:
creating, by a workbook manager, an input table on a cloud-based data warehouse in response to receiving a request, from a client computing system, to create the input table, wherein the input table is created with metadata columns that are not presented on the client computing system, wherein the workbook manager is included within an intermediary computing system between the client computing system and the cloud-based data warehouse;
presenting, by the workbook manager, the input table via a spreadsheet structure within a workbook, wherein the spreadsheet structure within the workbook enables a user of the client computing system to view and edit the input table;
selecting, by the workbook manager, a subset of columns of the input table stored in the cloud-based data warehouse, wherein the subset of columns excludes one or more of the metadata columns of the input table;
generating, by the workbook manager, a view of the input table based on the subset of columns; and
storing, by the workbook manager, the view of the input table in the cloud-based data warehouse accessible by a software application external to the workbook manager, wherein the one or more of the metadata columns are inaccessible by the software application via the view of the input table.
8 . The apparatus of claim 7 , wherein the subset of columns corresponds to a presentation of the input table in the workbook.
9 . The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out the step of receiving, by the workbook manager, a request from the client computing system to generate the view of the input table.
10 . The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from the client computing system, a modification to the input table; and
updating the view of the input table based on the modification.
11 . The apparatus of claim 10 , wherein the modification is received via the workbook presenting the input table.
12 . The apparatus of claim 7 , wherein the one or more of the metadata columns comprise one or more metadata columns generated during creation of the input table.
13 . A computer program product for creating data warehouse views for input 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:
creating, by a workbook manager, an input table on a cloud-based data warehouse in response to receiving a request, from a client computing system, to create the input table, wherein the input table is created with metadata columns that are not presented on the client computing system, wherein the workbook manager is included within an intermediary computing system between the client computing system and the cloud-based data warehouse;
presenting, by the workbook manager, the input table via a spreadsheet structure within a workbook, wherein the spreadsheet structure within the workbook enables a user of the client computing system to view and edit the input table;
selecting, by the workbook manager, a subset of columns of the input table stored in the cloud-based data warehouse, wherein the subset of columns excludes one or more of the metadata columns of the input table;
generating, by the workbook manager, a view of the input table based on the subset of columns; and
storing, by the workbook manager, the view of the input table in the cloud-based data warehouse accessible by a software application external to the workbook manager, wherein the one or more of the metadata columns are inaccessible by the software application via the view of the input table.
14 . The computer program product of claim 13 , wherein the subset of columns corresponds to a presentation of the input table in the workbook.
15 . The computer program product of claim 13 , wherein the computer program instructions further cause the computer to carry out the step of receiving, by the workbook manager, a request from the client computing system to generate the view of the input table.
16 . The computer program product of claim 13 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving, from the client computing system, a modification to the input table; and
updating the view of the input table based on the modification.
17 . The computer program product of claim 16 , wherein the modification is received via the workbook presenting the input table.