Abstract: The subject technology provides configurations for receiving a query for data stored across data systems in which the query is associated with a user. It is determined if the user has permission to execute an operation from the query at a data in which the operation is executed upon at least one table provided by the data system. The subject technology determines if the operation corresponds to a cache object in a cache registry if the user has permission. Each cache object is owned by a cache manager user. A view associated with the user is created that provides temporary access privileges to the cache object corresponding to the operation in which the cache object includes results of the operation executed in the query and the cache object is owned by the cache manager user. The results of the operation are then provided in the created view to the user.

Abstract: The subject technology provides querying structured and unstructured data across disparate incompatible systems with a single language and connection point. Cost based optimizations are provided for executing the query. In some configurations, logical plans for executing a query are generated. For each of the logical plans, the subject technology generates a set of physical plans for executing the query on data systems, determines an execution cost for each physical plan from the physical plans, and selects a respective physical plan with a lowest determined execution cost among the determined execution cost for each physical plan. A physical plan is then selected for execution with a lowest execution cost among the selected respective physical plans of each of the logical plans. Data from an operation from the query may then be persisted and then used for generating a new set of logical and physical plans for executing a remaining set of operations from the query.

Abstract: A computer-implemented method for exploring external data sources includes selecting a first function from a function library in a spreadsheet application based on a first user input, designating a first data source for the first function based on a second user input, wherein the first data source comprises a first dataset stored externally to the spreadsheet application, and arranging a first cell formula comprising the first function and a first identifier for the first data source in a first cell of a spreadsheet. The method further includes selecting an output function from the function library based on a third user input, designating a source function's reference based on a fourth user input, designating an output location in the spreadsheet based on a firth user input, and arranging a second cell formula including the selected output function, the designated source function's reference and the designated output location in a second cell of the spreadsheet.