Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for receiving a query provided by a user and comprising one or more terms. Obtaining context data based on at least a portion of a first resource displayed to the user at a time that the query is received. Obtaining a revised query that is based on the query and the context data. Receiving a plurality of search results responsive to the revised query. Automatically, selecting a search result that represents a second resource from the plurality of search results, and providing the second resource for display to the user.

Methods, systems, and apparatuses for generating notifications corresponding to queries submitted for execution by virtual warehouses are described herein. A request to execute a query may be received. An execution plan, for the query, may be identified. A processing complexity for the query may be predicted based on the query and the execution plan. A notification may be generated based on the processing complexity meeting an alert threshold. A user device may display the notification. A response to the notification comprising a selection of a first virtual warehouse, of a plurality of virtual warehouses, to execute the query may be received.

A computer-implemented system and method for creating forecast charts. The computer-implemented system includes a computing device, processor, and memory. The processor is configured to connect data sources to a website application. The processors are configured to retrieve, by the website application, unstructured data from the plurality of data sources. The processors are configured to format unstructured data and convert the unstructured data into structured data. The processors are configured to transform, by the website application, the structured data into one or more forecast charts by performing computations by using transformation methods. The structured data is used on dashboard templates, and independent metric templates, wherein at least one of dashboard template is selected from the plurality of dashboard templates presented over a user interface of the computing device by a user. The processors are configured to train Machine Learning (ML) models on the structured data of the dashboard templates. The processors are configured to deploy the ML models on a server. The server is connected to an application programming interface (API). The ML models utilize a recursive multi-step forecasting and adjust a parameter of the recursive multi-step forecasting to fit the structured data. The ML models are used to provide prediction data based on structured data. The processors are configured to create a dashboard based on the dashboard template selected by the user. The API receives and returns the prediction data to the web application where the forecast charts are displayed based on the prediction data.

Techniques are disclosed to migrate data via query co-evaluation. In various embodiments, an input data associated with a source database S and a target schema T to which the input data is to be migrated is received. A set of relational conjunctive queries from target schema T to source database S is received. Query co-evaluation is performed on the received set of relational conjunctive queries to transition data from source database S to target schema T.

Systems and methods are disclosed for implementing dual textual/graphical programming interfaces for programming streaming data processing pipelines. A user interface is provided that enables a user to author a processing pipeline as a query in a query language, and to request conversion of that query language into a graph data structure representation of the pipeline, which can be visualized in the interface. The interface further enables modification of the graph via interaction with the visualization. On request, the modified graph can be converted back into the query language, with the querying being modified to reflect the modifications to the graph.

Systems and methods for unifying business records data from different database sources into a common format in the same repository are disclosed. In one embodiment, a process includes receiving, by an integration platform system, a first set of business records data from a customer records system, where the business records data includes records in a first format, identifying a first transformation rule corresponding to the first format using the integration platform system, where the first transformation rule includes information for converting data from the first format to a unified format, converting each record in the first set of business records from the first format to the unified format by the integration platform system using the first transformation rule, and storing the first set of converted records in the unified format in a business records database.

During a query compilation process, a query is received that is directed to a set of source tables, each source table from the set of source tables being organized into at least one micro-partition and the query including at least one pruning operation. During the query compilation process, a modification of the query is performed for adjusting the at least one pruning operation, the modification being based on a set of statistics collected for previous pruning operations on at least a portion of the set of source tables and a set of heuristics, the set of statistics indicating at least an amount of execution time for each previous query associated with each of the previous pruning operations. The query is compiled including the modification of the query. The compiled query is provided to an execution node of a database system for execution.

Some embodiments provide a method of emulating a presentation of at least one system object of a first database, based on multiple system objects of a second database. From a client, the method receives a first query for the first database requesting a presentation of the system object. From a metadata storage, the method identifies a second query for the second database that references the system objects of the second database, and generates the requested presentation of the system object. The method replies to the client with the generated presentation.

A method and system are provided for searching a search query having a non-character-based input. The method comprises receiving the search query comprising a first part and a second part. The first part comprises a non-character-based input. The method further comprises identifying a first plurality of keywords associated with the non-character-based input and receiving a selection of at least one of the first plurality of keywords. The method further comprises generating a modified search query comprising the at least one selected keyword and the second part. The method further comprises retrieving search results based on the modified search query and generating for presentation the search results.

A query processing system generates and employs a hybrid inverted index of predicates for predicate statement evaluation. The query processing system converts a collection of predicate statements to two parts, a matrix and a set of reduced predicate statements. The query processing system then generates a hybrid inverted index that maps values for variables to predicates from the matrix and the reduced predicate statements that evaluate to true for corresponding values. When querying data, the query processing system performs a lookup on the hybrid inverted index to identify predicates from the matrix and reduced predicate statements that evaluate to true for values of variables for the data. The query processing system identifies predicate statements that evaluate to true by evaluating the matrix and reduced predicate statements using treating predicates identified from the hybrid inverted index as true.