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.

Abstract: Dependency tree-based copying and pasting including receiving, by a workbook manager from a client computing system, a request to paste a first workbook element from a first workbook to a second workbook, determining, by the workbook manager, that the first workbook element of the first workbook is in a first dependency relationship with one or more other workbook elements in the first workbook, copying, by the workbook manager, the one or more other workbook elements with the first workbook element to the second workbook, wherein the first dependency relationship is preserved after the copying, and presenting, by the workbook manager on the client computing system, the second workbook comprising the first workbook element and the one or more other workbook elements.

Abstract: Generating period-over-period calculations using a cloud-based data warehouse including receiving, from a client computing system, a request to add a comparison value column to a table, wherein the request comprises an identifier of a date column, an identifier of a base value column, and an identifier of a prior period; matching a first set of dates in the date column to a second set of dates in the date column using the identifier of the prior period; generating a database statement to create the comparison value column, including organizing the comparison value column using values corresponding to the second set of dates in the date column; retrieving the comparison value column from a cloud-based data warehouse using the database statement; and presenting, on the client computing system, the table comprising the comparison value column.