Abstract: Providing access to usage reports on a cloud-based data warehouse including maintaining, by a management module, a metadata table on the cloud-based data warehouse, wherein the metadata table comprises usage reports for a plurality of organizations; receiving, by the management module, a request for the metadata table from an administrator account for a first organization of the plurality of organizations; granting, by the management module, the administrator account permission to access a filtered portion of the metadata table, wherein the filtered portion of the metadata table is generated by filtering the metadata table by an organization identifier of the first organization; and providing, by the management module, the filtered portion of the metadata table to the administrator account.

Abstract: Augmenting decision-making via interactive what-if analysis including receiving, by a query execution engine, a state specification of a graphical user interface that includes a selection of driver importance variables that correlate to a target variable, generating, by the query execution engine, a database query using the received state specification, wherein the database query is composed to retrieve a query result from a cloud-based data warehouse, based on the query result, calculating, by the query execution engine, an importance value of each selected driver importance variable relative to the target variable, and presenting the calculated importance value in a driver importance view of the graphical user interface.

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: Top frequency worksheet filtering including sending a first request comprising a first search term; receiving, in response to the first request, a first plurality of distinct values having a greatest frequency in a data set and responsive to the first search term, wherein the first plurality of distinct values comprises a number of distinct values less than or equal to a size threshold; presenting the first plurality of distinct values; receiving a selection of a first value from the first plurality of distinct values; and filtering, based on the selected first value, a worksheet comprising a presentation of the data set.

Abstract: Tracking errors in data set lineage including receiving, from a user, a change to a model data set, wherein the model data set is a reusable modeling layer comprising at least a portion of a data source retrieved from a data warehouse; accessing a list of dependent worksheets utilizing the model data set as a data source wherein each dependent worksheet is configured to perform analysis on the portion of the first data source within the model data set without changing the model data set; generating an error report for the dependent worksheets utilizing the model data set; and providing, to the user, the error report for the dependent worksheets utilizing the model data set.

Abstract: Search using data warehouse grants including determining, for a user, one or more access grants for a cloud-based data warehouse, each of the access grants comprising an object identifier of a data object accessible to the user; generating a search query comprising one or more search terms and a filter based on each of the access grants; sending the search query to a search indexing service configured to maintain an index of the cloud-based data warehouse; and receiving, in response to the search query, first search results responsive to the one or more search terms and included in a scope based on the filter.

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 database query including determining a first order of operations for elements within the state specification; and sending the database query to the data warehouse.

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: Linking data sets, including receiving a selection of a first column of a first data set related to a second column of a second data set; in response to the selection, generating a query based on a relationship between the first column of the first data set and the second column of the second data set; and presenting a third data set based on a response to the query.

Abstract: Compiling optimized database statements including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface in response to a user manipulating the graphical user interface on the client computing system, wherein the state specification is in a standard file format and describes modifications to a plurality of visual elements of the graphical user interface; compiling, by the query compiler, a database statement from the state specification such that a limit clause within the database statement is processed by a database before at least one join clause; and sending, by the query compiler, the optimized database statement to a database on a cloud-based data warehouse.

Abstract: Syncing data warehouse permissions using single sign-on authentication including establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse; receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse; accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and sending a response to the first query based on the accessed first data.

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

Abstract: Servicing database requests using derivations of 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 that the canonical version of the requested table is derivable using a canonicalized table in the canonical table repository; and in response to determining that the canonical version of the requested table is derivable using the canonicalized table in the canonical table repository: transforming the canonicalized table in the canonical table repository based on the received request for the table, including deriving a portion of the requested table using the canonicalized table in the canonical table repository; and providing, to the client computing system, the transformed canonicalized table.

Abstract: Servicing database requests using canonicalized tables including receiving, from a client computing system, a request for a table from a database; determining that a canonical version of the requested table matches a canonicalized table in a canonical table repository; and providing, to the client computing system, the matching canonicalized table that is transformed based on the received request for the table.

Abstract: Sharing data across cloud-based data warehouses establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse; receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse; accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and sending a response to the first query based on the accessed first data.

Abstract: Creating a model data set using a spreadsheet interface including generating the model data set using the spreadsheet interface and a first data source from a data warehouse, wherein the model data set is a reusable modeling layer comprising at least a portion of the first data source, and wherein generating the model data set comprises: creating a first worksheet using the spreadsheet interface and the first data source; receiving an indication that the first worksheet is a model data set; and generating model data set metadata for the first worksheet; and providing, as a second data source for a second worksheet, the model data set generated from the model data set metadata.

Abstract: Managing database queries using a deconstructed cloud database including receiving, by a communications manager of the deconstructed cloud database, a state specification from a client computing system; converting, by a query optimizer of the deconstructed cloud database, the state specification into a query plan comprising a database query targeting an offloaded execution engine; retrieving, by a dispatcher of the deconstructed cloud database, query results from the offloaded execution engine using the database query; and presenting, by the communications manager, the query results to the client computing system.

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

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: Enabling editable tables on a cloud-based data warehouse including receiving, by a query manager from a query manager client, a request to create a referencing worksheet using, as a data source, a client-provided table; storing, by the query manager, the client-provided table on the cloud-based data warehouse; generating, by the query manager, a database query to create the referencing worksheet, wherein the database query targets the client-provided table on the cloud-based data warehouse; and issuing, by the query manager, the database query to the cloud-based data warehouse.