Timeseries

Timeseries datasets associate each data point with a specific timestamp, making them well suited for organizing and querying time-ordered observations.

Each timeseries dataset comes with a set of required and auto-generated fields for each data point.

Required fields

While the specific data fields between different time series datasets can vary, there are common fields that all time series datasets share.

time · Timestamp

The timestamp associated with each data point. Timestamps are always in UTC.

For indexing and querying, Tilebox truncates timestamps to millisecond precision. But Timeseries datasets may contain arbitrary custom Timestamp fields that store timestamps up to a nanosecond precision.

Auto-generated fields

id · UUID

A universally unique identifier (UUID) that uniquely identifies each data point. IDs are generated so that sorting them lexicographically also sorts them by time.

IDs generated by Tilebox are deterministic, meaning that ingesting the exact same data values into the same collection will always result in the same ID.

ingestion_time · Timestamp

The time the data point was ingested into the Tilebox API.

Creating a timeseries dataset

To create a timeseries dataset, use the Tilebox Console and select Timeseries Dataset as the dataset type. The required and auto-generated fields already outlined will be automatically added to the dataset schema.

Time-based queries

Timeseries datasets support time-based queries. To query a specific time interval, specify a time range when querying data from a dataset or a collection.