How Queries Work

Queries in the Narrative platform identify specific rows of data across one or more datasets, helping you extract the most relevant data for your purposes.

Queries function similarly to queries in a relational database structure: serving as sets of parameters that pinpoint specific rows of data from one or more datasets.

Queries

Queries are defined by parameters such as filters and attributes. Once set, they delve into the data, retrieving precise information based on your requirements. Depending on the existence of associated jobs, you can either view these jobs or load the query in the Data Studio.

Subscriptions

Subscriptions are jobs that run once or on a regular basis to execute a query. Every subscription outputs any data that results from the running of a query into a new Dataset. Subscriptions that run on a schedule add new data to the existing output Dataset. Subscriptions are managed by a budget and delivery cadence.

Forecasts

Forecasts are estimates that predict the outcome of running a query. They offer information on how many rows of data would be delivered, the processing costs to execute a query, and if requested other aggregations such as the suppliers that contribute to a query or aggregate counts requested in a query. Forecasts can be run either on sampled data, providing a directional estimate of the data that is contained within a query at no cost, or they can be run across all applicable data, offering a precise, point-in-time prediction (which is associated with a processing usage fee).

Jobs

Jobs are tasks within the Narrative's platform. Every operation, like running a forecast or a subscription, leads to the creation of a job. Jobs allow for tracking of these operations and their status.