Data Views

While Data Pools provide endpoints for ingesting data, Data Views provide endpoints for retrieving data. A Data View is linked to a a single Data Pool and exposes select fields

Grouping

When a field is grouped, aggregated records will be returned for each grouped field. The exact number of rows returned depend on the Data Shape. For Time Series views, this is one record per interval per grouped field. For aggregated views, this is one record per grouped field.

Data Shape

When requesting data from a Data View (via the egress api) the Data can be returned in a few different styles.

Time series

Time series views process data by a time interval. The output will contain one record per interval time (minute, hour, day, etc), per grouped field. The interval is based on a specific field from the data pool and other non grouped fields will be aggregated by a specified aggregation function.

Time series views are helpful for displaying trend charts like line and bar charts.

Aggregated

Aggregated views will return a single record for the entire dataset. All non-grouped fields will be aggregated based on the specified function.

Records

Record views will display raw Data Pool data. Nothing will be aggregated and the Data Pool records will each be returned.