Abstract: Join key propagation including receiving a request to generate a referencing worksheet linked from a data source worksheet, wherein the data source worksheet is a presentation of a data set organized in columns from two data source tables joined using a join key, and wherein the referencing worksheet presents at least a subset of the data set presented by the data source worksheet; retrieving data source worksheet metadata and the join key using a reference to the data source worksheet metadata in the request; determining an additional column from the two data source tables to add to the referencing worksheet, wherein the additional column is excluded from the data source worksheet; and creating, using the data source worksheet metadata and the join key, the referencing worksheet presenting the columns from the two data source tables with the additional column.

Abstract: Compiling a database query including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface comprising a worksheet, wherein the worksheet is a presentation of a data set from a data warehouse; converting, by the query compiler, the state specification into a worksheet algebra including determining a first order of operations for elements within the state specification, wherein the worksheet algebra comprises the first order of operations over a nested table; converting, by the query compiler, the worksheet algebra into a database query; and sending the database query to the data warehouse.

Abstract: Maintaining cardinality of rows while joining worksheets from a database including receiving a request to join, to a first worksheet, a second worksheet from the database; for each row in the first worksheet: generating a join row for data from the second worksheet on the database; in response to determining that there is at least one matching row in the second worksheet on the database: compare a maximum value and a minimum value for each column in each row of the at least one matching row; if the maximum value and the minimum value match, store a matching value in a corresponding column of the join row; and if the maximum value and the minimum value do not match, store a multiple value indication in the corresponding column of the join row; and presenting the join row adjacent to a corresponding row in the first worksheet.

Abstract: Generating a database query to dynamically aggregate rows of a data set including determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set; receiving a calculation for a third column within the spreadsheet structure; determining that the third column is on a same hierarchical level as the first column; and in response to determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.

Abstract: Enabling editable tables on a cloud-based data warehouse including receiving, by a query manager, a client-provided table; receiving, by the query manager from a query manager client, a request to create a referencing worksheet using, as data sources, the client-provided table and a database table on a cloud-based data warehouse; storing, by the query manager, the client-provided table in the schema storage location on the cloud-based data warehouse, wherein the schema storage location is a storage location on the cloud-based data warehouse to which the query manager has read and write access, and wherein the database table is external to the schema storage location; generating, by the query manager, a database query to create the referencing worksheet, wherein the database query targets the client-provided table in the schema storage location and the database table; and issuing, by the query manager, the database query to the cloud-based data warehouse.

Abstract: Generating a database query using a dimensional hierarchy within a graphical user interface including displaying a data set within a spreadsheet structure, wherein the data set comprises a plurality of columns; displaying a list structure comprising a first level and a second level; receiving a selection of a first column of the plurality of columns as a first key for the first level in the list structure; receiving a selection of a second column of the plurality of columns as a second key for the second level in the list structure; and in response to receiving the selection of the first column and receiving the selection of the second column and based on an order of the first key and the second key in the list structure, generating the database query defining a hierarchical relationship between the first column and the second column.

Abstract: Generating a database query to dynamically aggregate rows of a data set including determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set; receiving a calculation for a third column within the spreadsheet structure; determining that the third column is on a same hierarchical level as the first column; and in response to determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.