Using custom functions to access a cloud-based data warehouse
AssigneeSigma Computing, Inc.
InventorsJared A. Spickard, Dillon Morrison
Life of this patent
Estimating the term…
Abstract
Using custom functions to access a cloud-based data warehouse including: receiving, by a workbook manager from a client computing system, a call to a first user-defined function input to an element of a workbook, wherein the workbook presents a dataset from a cloud-based data warehouse, wherein the first user-defined function is defined in the workbook manager; and executing, by the workbook manager and in the cloud-based data warehouse, based on the call to the first user-defined function, a second user-defined function defined in the cloud-based data warehouse.
Claims15
A method for using custom functions to access a cloud-based data warehouse, the method comprising:
- receiving, by a workbook manager from a client computing system, a call to a first user-defined function input to an element of a workbook, wherein the workbook presents a dataset from a cloud-based data warehouse, wherein the first user-defined function is defined in the workbook manager and provided by a user that, when executed, performs operations in a definition of the first user-defined function and provides output;
- and
- executing, by the workbook manager and in the cloud-based data warehouse, based on the call to the first user-defined function, a second user-defined function defined in the cloud-based data warehouse, wherein executing the second user-defined function comprises sending, to the cloud-based data warehouse, a database statement comprising a call to the second user-defined function, and wherein the database statement comprises a structured query language (SQL) statement.
An apparatus for using custom functions to access 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:
- receiving, by a workbook manager from a client computing system, a call to a first user-defined function input to an element of a workbook, wherein the workbook presents a dataset from a cloud-based data warehouse, wherein the first user-defined function is defined in the workbook manager and provided by a user that, when executed, performs operations in a definition of the first user-defined function and provides output;
- and
- executing, by the workbook manager and in the cloud-based data warehouse, based on the call to the first user-defined function, a second user-defined function defined in the cloud-based data warehouse, wherein executing the second user-defined function comprises sending, to the cloud-based data warehouse, a database statement comprising a call to the second user-defined function, and wherein the database statement comprises a structured query language (SQL) statement.
A computer program product for using custom functions to access a cloud-based data warehouse, the computer program product disposed upon a non-transitory computer readable storage medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out:
- receiving, by a workbook manager from a client computing system, a call to a first user-defined function input to an element of a workbook, wherein the workbook presents a dataset from a cloud-based data warehouse, wherein the first user-defined function is defined in the workbook manager and provided by a user that, when executed, performs operations in a definition of the first user-defined function and provides output;
- and
- executing, by the workbook manager and in the cloud-based data warehouse, based on the call to the first user-defined function, a second user-defined function defined in the cloud-based data warehouse, wherein executing the second user-defined function comprises sending, to the cloud-based data warehouse, a database statement comprising a call to the second user-defined function, and wherein the database statement comprises a structured query language (SQL) statement.
Dependencies are inferred from the claim text.