Abstract: The present invention relates to methods, apparatus, and products for generating a data warehouse index. Generating a data warehouse index includes storing a refresh token for a user and obtaining, automatically without user interaction, an access token for the user from an identity provider. Subsequently, one or more queries are submitted to a data warehouse requesting connection information for data structures of the data warehouse accessible by the user. During the query submission, the access token for authorization of the user is provided to the data warehouse. One or more responses are then received from the data warehouse specifying connection information for data structures of the data warehouse accessible by the user. Finally, an index of the data warehouse for the user based on the received connection information for data structures of the data warehouse accessible by the user.

Abstract: Prefetching query results using expanded queries including generating a database query using a state specification of a graphical user interface, wherein the database query is composed to retrieve initial results from a cloud-based data warehouse; determining that the database query is expandable; modifying the database query to retrieve expanded results from the cloud-based data warehouse, wherein the expanded results include the initial results; and fetching, from the cloud-based data warehouse, the expanded results using the modified database query.

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: Transient exploratory editing of input tables on a data warehouse including: presenting, on a client computing system by a workbook manager, an input table in a cloud-based data warehouse, wherein the input table is presented in an exploration mode that displays edits to the input table without altering the input table in the cloud-based data warehouse; receiving, by the workbook manager, a change to the input table; and modifying, by the workbook manager, a presentation of the input table reflecting the change without modifying the input table in the cloud-based data warehouse.

Abstract: Using lightweight references to present a worksheet including receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account; determining that the request was not generated from the second user account; and in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode, wherein permissions in the view mode prevent destructive edits to the worksheet and allow additive edits to the worksheet.

Abstract: Distributing dataset requests across service tiers including generating, by a workbook client, a dataset request for a dataset to populate a workbook for presentation on a client computing system, wherein data for the dataset is stored on a cloud-based data warehouse; determining, by the workbook client, a set of service tiers capable of servicing at least a portion of the dataset request, wherein the set of service tiers comprises the cloud-based data warehouse; selecting, by the workbook client from the set of service tiers, a combination of service tiers to service the dataset request based on at least one selection policy; and issuing, by the workbook client, the dataset request to the selected combination of service tiers.

Abstract: Editing data sets via non-editable workbooks including presenting, by a workbook manager on a client computing system, a workbook in an exploration mode that displays edits to the workbook without altering the workbook, wherein the workbook presents a data set from a cloud-based data warehouse; receiving, by the workbook manager via the workbook, a change to the workbook and an edit to the data set from a client account associated with the client computing system; determining, by the workbook manager, that the client account is authorized to edit the data set on the cloud-based data warehouse and that the client account lacks authorization to commit changes to the workbook; and applying, by the workbook manager, the edit to the data set in the cloud-based data warehouse.

Abstract: Managing access to usage data on a cloud-based data warehouse including storing, by a table manager, usage data for a plurality of organizations in a table within a cloud-base data warehouse; receiving, by the table manager from a first client, a request for usage data for a first organization of the plurality of organizations, wherein the first client is associated with the first organization; and retrieving, by the table manager, the requested usage data for the first organization using a parameterized connection to the cloud-based data warehouse, wherein the parameterized connection provides access to the usage data for the first organization and blocks access to usage data for each other organization in the plurality of organizations.

Abstract: Versioning in editable tables including receiving, by a table manager via a client computing system, an instruction to edit a first row in an editable table in a cloud-based data warehouse, wherein the instruction comprises a column value; determining, by the table manager, a version value for the edit to the first row; and generating, by the table manager, a database statement instructing the cloud-based data warehouse to create, in the editable table, a second row including the version value and the column value.

Abstract: Live editing a workbook with multiple clients including receiving, by a table manager, a request by a first client on a first client computing system to edit a workbook in an exploration mode that displays edits to the workbook without altering the workbook; receiving, by the table manager from the first client, an exploration edit targeting the exploration of the workbook; applying, by the table manager, the exploration edit to the exploration of the workbook; and presenting, by the table manager to a second client on a second client computing system, the application of the exploration edit to the exploration of the workbook.

Abstract: Live editing a workbook with multiple clients including receiving, by a workbook manager from a first workbook client, a first workbook patch comprising a base version ID and a first workbook edit; determining, by the workbook manager, that the base version ID from the first workbook patch matches the version ID for a confirmed workbook on the workbook manager; applying, by the workbook manager, the first workbook edit to the confirmed workbook on the workbook manager; advancing, by the workbook manager, the version ID for the confirmed workbook; and sending, by the workbook manager, an acknowledgement of the first workbook patch to the first workbook client.

Abstract: Generating edited input tables for low-latency presentation including receiving, by the 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 the cloud-based data warehouse; generating, by the workbook manager, a database statement to retrieve the input table from the cloud-based data warehouse, wherein generating the database statement comprises: determining that a cache on the intermediary computing system includes an uncommitted input table edit; and inserting the uncommitted input table edit into the database statement; retrieving, by the workbook manager, query results from the cloud-based data warehouse using the database statement, wherein the query results comprise the input table and the uncommitted input table edit; and providing, by the workbook manager, the query results to the first workbook client on the first client computing system.

Abstract: Cost attribution using resource switching including receiving, by a workbook manager from a first client computing system, a first request for a workbook presenting a dataset from a cloud-based data warehouse, wherein the first request comprises a first user attribute; selecting, by the workbook manager, a first resource warehouse on the cloud-based data warehouse based on the first user attribute, wherein the first resource warehouse tracks resources used to service data requests on the cloud-based data warehouse; retrieving, by the workbook manager, the dataset from the cloud-based data warehouse using the first resource warehouse matched to the first user attribute; and presenting, on the first client computing system by the workbook manager, the workbook presenting the dataset.

Abstract: Augmenting decision-making via interactive what-if analysis including presenting, by a query execution engine, via a graphical user interface, a constrained analysis view that indicates a set of values for a plurality of driver variables, where the graphical user interface receives requests for data and present data; receiving a state specification of the graphical user interface that includes a constraint on a value of a driver variable of the plurality of driver variables; generating, by the query execution engine, a database query using the received state specification that is composed to retrieve a query result from a cloud-based data warehouse; based on the query result, calculating an updated set of values for the plurality of driver variables that result in an optimized value for the target variable while the constraint on the driver variable is in effect; and presenting the updated set of values in an updated view.

Abstract: Directly accessing and organizing data sets from a data warehouse including receiving, by a data analyzer, a request from a service provider client instructing the data analyzer to retrieve a data set from a service provider data warehouse, wherein the service provider client is a client of a service provider, wherein the service provider data warehouse stores data sets for the service provider, and wherein the service provider client accesses the data analyzer and the service provider data warehouse without providing credentials; retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider; organizing, by the data analyzer, the data set into a worksheet; and presenting, by the data analyzer to the service provider client, the worksheet comprising the data set.

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