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.

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: Annotating data points on a workbook element, including: receiving, by a workbook manager from a client computing system, an annotation for a data point of an element of a workbook, wherein the workbook presents a dataset from a cloud-based data warehouse; and storing, by the workbook manager and into the cloud-based data warehouse, the annotation in association with a record in the dataset corresponding to the data point.

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