Enabling editable tables on a cloud-based data warehouse
Enabling editable tables on a cloud-based data warehouse including receiving, by a query manager, a client-provided table; receiving, by the query manager from a query manager client, a request to create a referencing worksheet using, as data sources, the client-provided table and a database table on a cloud-based data warehouse; storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access, and wherein the database table is external to the schema storage location; generating, by the query manager, a database query to create the referencing worksheet, wherein the database query targets the client-provided table in the schema storage location and the database table; and issuing, by the query manager, the database query to the cloud-based data warehouse.
1. A method of enabling editable tables on a cloud-based data warehouse, the method comprising:
receiving, by a query manager, a client-provided table;
storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access;
generating, by the query manager, a database query to create a worksheet using the client-provided table as a data source, wherein the database query targets the client-provided table in the schema storage location; and
issuing, by the query manager, the database query to the cloud-based data warehouse.
2. The method of claim 1 , further comprising:
receiving, by the query manager from the query manager client, an update for the client-provided table; and
applying, by the query manager, the update to the client-provided table stored in the schema storage location on the cloud-based data warehouse.
3. The method of claim 1 , further comprising:
receiving a request to create a worksheet by joining the client-provided table and a database table.
4. The method of claim 1 , wherein the database query comprises an instruction, to the cloud-based data warehouse, to perform a computation using the client-provided table in the schema storage location.
5. The method of claim 1 ,
wherein receiving, by the query manager, the client-provided table comprises maintaining an updated copy of the client-provided table, and
wherein storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse comprises sending, by the query manager, the updated copy of the client provided table to the schema storage location on the cloud-based storage warehouse.
6. The method of claim 1 , wherein the client-provided table comprises a join key to a database table.
7. The method of claim 1 , wherein the query manager has read-only access to a database table on the cloud-based data warehouse.
8. An apparatus for enabling editable tables on a cloud-based 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 query manager, a client-provided table;
storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access;
generating, by the query manager, a database query to create a worksheet using the client-provided table as a data source, wherein the database query targets the client-provided table in the schema storage location; and
issuing, by the query manager, the database query to the cloud-based data warehouse.
9. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, by the query manager from the query manager client, an update for the client-provided table; and
applying, by the query manager, the update to the client-provided table stored in the schema storage location on the cloud-based data warehouse.
10. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving a request to create a worksheet by joining the client-provided table and a database table.
11. The apparatus of claim 8 , wherein the database query comprises an instruction, to the cloud-based data warehouse, to perform a computation using the client-provided table in the schema storage location.
12. The apparatus of claim 8 ,
wherein receiving, by the query manager, the client-provided table comprises maintaining an updated copy of the client-provided table, and
wherein storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse comprises sending, by the query manager, the updated copy of the client provided table to the schema storage location on the cloud-based storage warehouse.
13. The apparatus of claim 8 , wherein the client-provided table comprises a join key to a database table.
14. The apparatus of claim 8 , wherein the query manager has read-only access to a database table on the cloud-based data warehouse.
15. A computer program product for enabling editable tables on a cloud-based 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 query manager, a client-provided table;
storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access;
generating, by the query manager, a database query to create a worksheet using the client-provided table as a data source, wherein the database query targets the client-provided table in the schema storage location; and
issuing, by the query manager, the database query to the cloud-based data warehouse.
16. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving, by the query manager from the query manager client, an update for the client-provided table; and
applying, by the query manager, the update to the client-provided table stored in the schema storage location on the cloud-based data warehouse.
17. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving a request to create a worksheet by joining the client-provided table and a database table.
18. The computer program product of claim 15 , wherein the database query comprises an instruction, to the cloud-based data warehouse, to perform a computation using the client-provided table in the schema storage location.
19. The computer program product of claim 15 ,
wherein receiving, by the query manager, the client-provided table comprises maintaining an updated copy of the client-provided table, and
wherein storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse comprises sending, by the query manager, the updated copy of the client provided table to the schema storage location on the cloud-based storage warehouse.
20. The computer program product of claim 15 , wherein the client-provided table comprises a join key to a database table.