SIGMA COMPUTING, INC.

Third-party addresses for embedded workbooks including receiving, by a workbook manager from a third-party user computing system, a request for a network address of a third-party domain including an embedded workbook, wherein the embedded workbook is embedded in the third-party domain and presents data from a cloud-based data warehouse; retrieving, by the workbook manager, a workbook identifier that identifies the embedded workbook, an embed identifier that identifies an embedding element, and a third-party domain identifier that identifies the third-party domain; generating, by the workbook manager, the network address of the third-party domain including the embedded workbook using the workbook identifier, the embed identifier, and the third-party domain identifier; and presenting, by the workbook manager on the third-party user computing system, the generated network address of the embedded workbook.

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.

Adding a column into a worksheet, including: receiving, via a spreadsheet interface comprising a first worksheet, a request to add a new column to the first worksheet, wherein the request includes a key that identifies a reference column in the first worksheet, a specification of a second worksheet that comprises a corresponding reference column related by the key, and a specification of a data column in the second worksheet, wherein each entry of the data column is associated with an entry of the corresponding reference column in the second worksheet, and entries to be included in the requested new column will be based on the entries of the data column; generating, based on the request, a database query; and receiving, from a database and in response to the database query, a query result comprising the new column to be added to the first worksheet.

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.

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.

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.

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.

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.

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.

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.