Abstract: Evaluating stored query results including generating a database query using a state specification of a graphical user interface, wherein the database query is composed to retrieve a current query result from a cloud-based data warehouse; searching a cache local to the query execution engine for the current query result, wherein the cache comprises a first previous query result from the cloud-based data warehouse; determining, based on the searching, that the current query result may be generated using the first previous query result from the cache; and creating the current query result using at least a portion of the first previous query result from the cache.

Abstract: Column-level security for embedded workbooks including receiving, by a workbook manager from a third-party user computing system, a request for an embedded workbook, wherein the request comprises a user attribute, and wherein the workbook is generated using a dataset comprising a set of columns; selecting, by the workbook manager, a subset of the set of columns of the dataset to include in the workbook based on the user attribute; retrieving, by the workbook manager, the selected subset of columns from a cloud-based data warehouse; and presenting, by the workbook manager on the third-party user computing system, the workbook comprising the selected subset of columns.

Abstract: Automatic rewriting of subtotal calculations including presenting, by a table manager, a spreadsheet structure on a GUI of a client computing system, wherein the spreadsheet structure presents a data set from a cloud-based data warehouse; receiving, at a first column of the spreadsheet structure by the table manager, a formula that includes a reference to a second column of the spreadsheet structure, wherein the formula is received from the client computing system; detecting, by the table manager, that the second column includes a subtotal calculation of a third column of the spreadsheet structure; and rewriting, by the table manager, the formula by replacing the reference to the second column with the subtotal calculation of the third column.

Abstract: Managing team access to workbooks embedded in client domains including hosting, by a workbook manager, a workbook embedded in a client domain accessible by a plurality of third-party user accounts divided into a plurality of teams, wherein each of the plurality of teams accesses a different underlying data set through the workbook; receiving, by the workbook manager from a client computing system, a request to create a team administrator account for a first team of the plurality of teams; and creating, by the workbook manager, the team administrator account with authorization to manage the workbook for the first team and without authorization to manage the workbook for third-party user accounts outside the first team.

Abstract: Managing worksheet access including receiving a request from a first user account to access a worksheet shared from a second user account, wherein the worksheet comprises a worksheet architecture for at least one data set from a database; determining that the first user account is authorized to access the worksheet architecture of the worksheet; determining that the first user account is authorized to access the at least one data set presented by the worksheet; and granting the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is authorized to access the at least one data set presented by the worksheet.

Abstract: Database writeback using an intermediary statement generator including receiving, by a statement generator, a table update request to update a table within a database on a cloud-based data warehouse, wherein the table update request comprises an update value and a selection of a row and a column from the table; verifying, by the statement generator, that the selection is updatable; generating, by the statement generator based on the selection and in response to the verification, an update database statement comprising a table identifier, a column identifier, a row identifier, and the update value; and sending, by the statement generator, the update database statement to the database on the cloud-based data warehouse, wherein the table of the database is updated in response to receiving the update database statement.

Abstract: Live editing editable tables including receiving, via a client computing system by a table manager, a request for an editable table stored on a cloud-based data warehouse; determining, by the table manager, that an uncommitted edit to the editable table exists, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse at a time when the request was received; redirecting, by the table manager, the request for the editable table to an edit queue accessible by the table manager, wherein the edit queue comprises the uncommitted edit; servicing by the table manager, the request for the editable table by combining the uncommitted edit from the edit queue with the editable table from the cloud-based data warehouse; and presenting, by the table manager, the editable table on the client computing system.

Abstract: Dashboard loading using a filtering query from a cloud-based data warehouse cache, including determining that a filtered result for a first filtering query is stored in a cache of a cloud-based data warehouse; sending, in response to the filtered result being stored in the cache, to the cloud-based data warehouse, a request for the filtered result from the cache; and providing, based on the filtered result for the first filtering query, one or more dashboard visualizations.

Abstract: Servicing database requests using canonicalized tables including maintaining a canonical table repository of canonicalized tables, wherein each canonicalized table is a transformed version of a table previously retrieved from a database; receiving, from a client computing system, a request for a table from the database; generating a description of a canonical version of the requested table; determining whether the canonical version of the requested table matches a canonicalized table in the canonical table repository; and if the canonical version of the requested table matches the canonicalized table in the canonical table repository: transforming the matching canonicalized table based on the received request for the table; and providing, to the client computing system, the transformed matching canonicalized table.

Abstract: Creating data warehouse views for input tables including: selecting, by a workbook manager, a subset of columns of an input table stored in a cloud-based data warehouse, wherein the subset of columns excludes one or more metadata columns of the input table; generating, by the workbook manager, a view of the input table based on the subset of columns; and storing, by the workbook manager, the view of the input table in the cloud-based data warehouse.

Abstract: Creating input tables accessible by multiple account roles including receiving, from a client computing system by a data visualizer, a request to create an input table at a destination location on a cloud-based data warehouse, wherein the request is associated with a first account role; determining, by the data visualizer, that the first account role has access to the destination location based on a set of permissions associated with the destination location; and creating, on the cloud-based data warehouse by the data visualizer, the input table that inherits the set of permissions from the destination location on the cloud-based data warehouse.

Abstract: 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.

Abstract: Editing data-warehouse tables using managed input tables including presenting, by a table manager via a client computing system, a base table from a cloud-based data warehouse; receiving, by the table manager, an instruction to modify the base table, wherein the instruction comprises a table edit; applying, by the table manager, the table edit to an input table on the cloud-based data warehouse; and creating, by the table manager, a modified base table by generating a database statement composed to combine the base table with the input table.

Abstract: Generating edited input tables for low-latency presentation including receiving, by a workbook manager on an intermediary computing system from a first workbook client on a first client computing system, a request for an input table on a cloud-based data warehouse, wherein the intermediary computing system and the cloud-based data warehouse are separate and distinct systems; generating, by the workbook manager, a database statement comprising an uncommitted edit, wherein the database statement configured to retrieve the input table from the cloud-based data warehouse and combine the input table with the uncommitted edit; and providing, by the workbook manager, the input table comprising the uncommitted edit to the first workbook client on the first client computing system.

Abstract: Editing and updating database tables on a cloud-based data warehouse including receiving, by a table manager via a client computing system, an instruction to edit a modified base table on the cloud-based data warehouse, wherein the instruction comprises a table edit targeting the modified base table; locating, by the table manager, a modifications table on the cloud-based data warehouse associated with the modified base table, wherein the modified base table comprises a base table and the modifications table; and servicing the instruction to edit the modified base table by generating a database statement targeting the cloud-based data warehouse to apply the table edit to the modifications table associated with the modified base table.

Abstract: Exposing parameters in referencing worksheets including receiving a request for a referencing worksheet linked from a data source worksheet, wherein the data source worksheet is a presentation of a data set from a database, and wherein the data source worksheet comprises a function utilizing an exposable parameter; generating the referencing worksheet from the data source worksheet, wherein the referencing worksheet exposes the exposable parameter without exposing the function utilizing the exposable parameter; and presenting the referencing worksheet with the exposable parameter without allowing access to the function utilizing the exposable parameter.

Abstract: Audit logging for input tables on a data warehouse including: receiving, by a workbook manager from a client computing system, a modification to an input table of a plurality of input tables stored in a cloud-based data warehouse; and storing, by the workbook manager, in an audit table stored in the cloud-based data warehouse, an entry describing the modification to the input table, wherein the audit table is configured to store entries describing modifications to any of the plurality of input tables.

Abstract: Creating accessible model data sets including receiving, by a query manager via a spreadsheet interface, an instruction to create a model data set using a data source from a data warehouse, wherein the model data set is a reusable modeling layer comprising at least a portion of the data source; building, by the query manager using the instruction to create the model data set, a first query statement comprising instructions to generate the model data set from the portion of the data source; and storing, by the query manager, the first query statement in a schema storage location within the data warehouse.

Abstract: Assigning sequence numbers in editable tables including receiving, by a table manager via a client computing system, an instruction to create a new row on an editable table in a cloud-based data warehouse, wherein the instruction comprises a column value and a row identifier of an adjacent row; calculating, by the table manager, a sequence value for a sequence column of the new row based on the row identifier of the adjacent row; and generating, by the table manager, a database statement instructing the cloud-based data warehouse to add the new row, including the column value and sequence value, to the editable table on the cloud-based data warehouse.

Abstract: Live editing editable tables including receiving, via a client computing system by a table manager on an intermediary computing system, a request for an editable table stored on a cloud-based data warehouse; determining, by the table manager, that the requested editable table includes an uncommitted edit, wherein the uncommitted edit is an edit made to the editable table that has not been committed to the cloud-based data warehouse; redirecting, by the table manager, the request for the editable table to an edit queue on the intermediary computing system, wherein the edit queue comprises the uncommitted edit; and servicing, by the table manager, the request for the editable table using the edit queue on the intermediary computing system.