points_string#

String time series: enum labels, state names, identifiers, and other text-valued channels.

Telemetry table, so every query must filter by dataset_rid.

For what a channel is, see Channels in the data model.

Columns#

Column	Type	Nullable	Notes
`ts`	`TIMESTAMP`	No	Sample time, nanosecond precision.
`value`	`VARCHAR`	Yes	The sample. Null where a sample exists but carries no value.
`channel`	`VARCHAR`	No	Channel name.
`dataset_rid`	`VARCHAR`	No	Dataset the sample belongs to. Required in the `WHERE` clause.
`tags`	`MAP`	No	Key-value pairs recorded with the series. See Filtering by tag.

Examples#

Read a state channel in time order:

SELECT ts, value
FROM points_string
WHERE dataset_rid = '<dataset-rid>'
  AND channel = 'flight_mode'
ORDER BY ts
LIMIT 1000

Count how often each distinct value appeared:

SELECT value AS mode, COUNT(*) AS samples
FROM points_string
WHERE dataset_rid = '<dataset-rid>'
  AND channel = 'flight_mode'
GROUP BY value
ORDER BY samples DESC

String comparison is case-sensitive, so match the value exactly as recorded. UPPER and LOWER are available if you need to normalize:

SELECT ts, value
FROM points_string
WHERE dataset_rid = '<dataset-rid>'
  AND UPPER(value) = 'ARMED'
ORDER BY ts

Next steps#

Function reference: the available string functions.
points_struct: structured values rather than plain text.