- Extractors
- Analyze Data
Supported Fields for the Timeseries Data Points
The DataMosaix timeseries can have either numeric or string data, so there are 2 columns for each data type. The value will be present in any one of them. This table will return 0 rows if queried without a filter on internal or external id. So timeseries_ID or external_ID is mandatory in where clause to fetch the data. The
timeseries_datapoints
tables include the actual data points for a timeseries. This table has the following columns:Column Name | Data Type | Description |
|---|---|---|
timeseries_id | BIGINT | Internal ID of the timeseries. |
external_id | VARCHAR | External ID of the timeseries. |
timestamp_utc | DATETIME | Recorded timestamp of the data points. |
value_numeric | DOUBLE | The numeric value of the data point if is_string is false otherwise null. |
value_string | TEXT | The string value of the data point if is_string is true otherwise null |
is_step | BOOL | TRUE if data point is a step |
is_string | BOOL | TRUE if data point is a string |
Provide Feedback