# US 12,717,816 B1 · Using custom functions to access a cloud-based data warehouse > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,717,816 B1 - Document ID: US12717816B1 - Status: Granted - Kind: B1 - Application number: 18/423,646 - Filed: 2024-01-26 - Granted: 2026-08-25 - Earliest claimed: 2024-01-26 - Assignees: Sigma Computing, Inc. - Applicants: Sigma Computing, Inc. - Inventors: Jared A. Spickard; Dillon Morrison - Web page: https://patentgrep.com/patent/US12717816B1 ## CPC - G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP} - G06F 16/2455: Query execution - G06F 16/248: Presentation of query results - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## 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. ## Claims ### Claim 1 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. ### Claim 2 (depends on 1) The method of claim 1, wherein the call to the second user-defined function comprises one or more parameters of the first user-defined function. ### Claim 3 (depends on 1) The method of claim 1, further comprising receiving, by the workbook manager from the cloud-based data warehouse, a response to the database statement based on an execution of the second user-defined function in the cloud-based data warehouse. ### Claim 4 (depends on 3) The method of claim 3, further comprising updating a presentation of the workbook based on the response to the database statement. ### Claim 5 (depends on 1) The method of claim 1, further comprising receiving, by the workbook manager, a definition of the first user-defined function, wherein the definition of the first user-defined function maps the first user-defined function in the workbook manager to the second user-defined function defined in the cloud-based data warehouse. ### Claim 6 (depends on 5) The method of claim 5, further comprising storing, by the workbook manager, the definition of the first user-defined function. ### Claim 7 (depends on 1) The method of claim 1, wherein the element of the workbook comprises a formula input element and wherein the call to the first user-defined function comprises a function in a formula input to the formula input element. ### Claim 8 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. ### Claim 9 (depends on 8) The apparatus of claim 8, wherein the call to the second user-defined function comprises one or more parameters of the first user-defined function. ### Claim 10 (depends on 8) The apparatus of claim 8, wherein the computer program instructions further cause the apparatus to carry out the step of receiving, by the workbook manager from the cloud-based data warehouse, a response to the database statement based on an execution of the second user-defined function in the cloud-based data warehouse. ### Claim 11 (depends on 10) The apparatus of claim 10, wherein the computer program instructions further cause the apparatus to carry out the step of updating a presentation of the workbook based on the response to the database statement. ### Claim 12 (depends on 8) The apparatus of claim 8, wherein the computer program instructions further cause the apparatus to carry out the step of receiving, by the workbook manager, a definition of the first user-defined function, wherein the definition of the first user-defined function maps the first user-defined function in the workbook manager to the second user-defined function defined in the cloud-based data warehouse. ### Claim 13 (depends on 12) The apparatus of claim 12, wherein the computer program instructions further cause the apparatus to carry out the step of storing, by the workbook manager, the definition of the first user-defined function. ### Claim 14 (depends on 8) The apparatus of claim 8, wherein the element of the workbook comprises a formula input element and wherein the call to the first user-defined function comprises a function in a formula input to the formula input element. ### Claim 15 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.