Executing workbook code within a cloud-based data warehouse
Executing workbook code within a cloud-based data warehouse including receiving, by a workbook manager from a client computing system, analysis code via a workbook presented on the client computing system, wherein the analysis code references data on a cloud-based data warehouse; executing, by the workbook manager, the analysis code on the cloud-based data warehouse using the referenced data to generate analysis output; and presenting, by the workbook manager, the analysis output within the workbook on the client computing system.
1 . A method comprising:
receiving, by a workbook manager from a client computing system, analysis code within a workbook element of a workbook presented on the client computing system, wherein the analysis code references data on a cloud-based data warehouse;
executing, by the workbook manager, the analysis code on the cloud-based data warehouse using the referenced data to generate analysis output, including:
sending, to the cloud-based data warehouse, the analysis code for interpretation using computing resources on the cloud-based data warehouse, and
directing the analysis output to a storage location on the cloud-based data warehouse; and
presenting, by the workbook manager, the analysis output within the workbook on the client computing system.
2 . The method of claim 1 , wherein executing the analysis code on the cloud-based data warehouse comprises storing the analysis output on the cloud-based data warehouse.
3 . The method of claim 2 , further comprising:
receiving a request to create a new workbook element that references the analysis output on the cloud-based data warehouse.
4 . The method of claim 3 , wherein the new workbook element that references the analysis output includes structured query language code.
5 . The method of claim 1 , wherein the analysis code is Python code.
6 . The method of claim 1 , wherein the analysis code is interpreted on the cloud-based data warehouse.
7 . The method of claim 1 , wherein executing the analysis code on the cloud-based data warehouse comprises launching a virtual machine on the cloud-based data warehouse and executing the analysis code using the virtual machine.
8 . The method of claim 1 , wherein the referenced data on the cloud-based data warehouse is stored within a database.
9 . The method of claim 1 , wherein the analysis code also references data within a workbook element on the workbook presented on the client computing system.
10 . The method of claim 1 , wherein the workbook manager is on an intermediary computing system between the client computing system and the cloud-based data warehouse.
11 . A system comprising:
a memory; and
a processing device, operatively coupled to the memory, the processing device configured to:
receive, from a client computing system, analysis code within a workbook element of a workbook presented on the client computing system, wherein the analysis code references data on a cloud-based data warehouse;
execute the analysis code on the cloud-based data warehouse using the referenced data to generate analysis output, including:
sending, to the cloud-based data warehouse, the analysis code for interpretation using computing resources on the cloud-based data warehouse, and
directing the analysis output to a storage location on the cloud-based data warehouse; and
present the analysis output within the workbook on the client computing system.
12 . The system of claim 11 , wherein executing the analysis code on the cloud-based data warehouse comprises storing the analysis output on the cloud-based data warehouse.
13 . The system of claim 12 , wherein the processing device is further configured to receive a request to create a new workbook element that references the analysis output on the cloud-based data warehouse.
14 . The system of claim 13 , wherein the new workbook element that references the analysis output includes structured query language code.
15 . The system of claim 11 , wherein the analysis code is Python code.
16 . The system of claim 11 , wherein the analysis code is interpreted on the cloud-based data warehouse.
17 . The system of claim 11 , wherein executing the analysis code on the cloud-based data warehouse comprises launching a virtual machine on the cloud-based data warehouse and executing the analysis code using the virtual machine.
18 . The system of claim 11 , wherein the referenced data on the cloud-based data warehouse is stored within a database.
19 . The system of claim 11 , wherein the analysis code also references data within a workbook element on the workbook presented on the client computing system.
20 . A non-transitory computer readable storage medium storing instructions which, when executed, cause a processing device to:
receive, from a client computing system, analysis code within a workbook element of a workbook presented on the client computing system, wherein the analysis code references data on a cloud-based data warehouse;
execute the analysis code on the cloud-based data warehouse using the referenced data to generate analysis output, including:
sending, to the cloud-based data warehouse, the analysis code for interpretation using computing resources on the cloud-based data warehouse, and
directing the analysis output to a storage location on the cloud-based data warehouse; and
present the analysis output within the workbook on the client computing system.