Knowledge Base

How Queries Work

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.

Materialized Views

Materialized views are jobs that run once or on a regular basis to execute a query. Every materialized view outputs data into a new Dataset with a scheme defined by the query. Materialized views that run on a schedule add new data to the existing output dataset by appending to or overwriting data.

Forecasts

Forecasts are estimates that predict the outcome of running a query. They reveal 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. 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 quer, leads to the creation of a job. Jobs allow for tracking of these operations and their status.

< Back
Rosetta

Hi! I’m Rosetta, your big data assistant. Ask me anything! If you want to talk to one of our wonderful human team members, let me know! I can schedule a call for you.