Azure Time Series Insights
Azure Time Series Insights is an end-to-end Platform-As-A-Service offering to ingest, process, store, and query highly contextualized, time-series-optimized IoT-scale data that’s ideal for ad-hoc data exploration, as well as operational analysis. Azure TSI is a uniquely extensible and customized service offering that meets the broad needs of industrial IoT deployments.
More details about the service are available Time Series Insights documentation.
-
Increase the limit of events that can be downloaded by TSI
Downloading events from TSI is currently limited to 10000 events. This is probably because the query API is limited to 10000 events per query. Please consider increasing this limit.
14 votes -
Microsoft.Azure.TimeSeriesInsights should be available on NuGet
For C# users, a NuGet package should be made available for working with the TSI Query API.
There is some code already here: https://github.com/Azure-Samples/Azure-Time-Series-Insights/tree/master/csharp-tsi-preview-sample/DataPlaneClient/Generated
12 votes -
Retrieve markers added by users on charts
It could be greate to be able to retrieve via API markers that analysts have spotted using Azure TSI, in order to persist and use those markers elsewhere.
7 votes -
Increase maximum number of concurrent connections per environment
Currently, only 20 concurrent connections are allowed which limits usage of the API heavily. Would be great if this was increased to a larger amount per environment.
7 votes -
Add the possibility to group events by an event variable/property in Aggregate Series API (Gen2)
It is currently not possible to do "group by" queries in TSI Gen 2 although it was possible in Gen 1 (https://docs.microsoft.com/en-us/rest/api/time-series-insights/gen1-query-api#get-environment-aggregates-api).
This seemed to be on the roadmap (fleet queries) but it should be proritized to allow migration between Gen1 and Gen2.
5 votes -
DayOfWeek in DateTime Functions
You can get the monthOfYear and the dayOfMonth but not the dayOfWeek. For our requirements it would be very helpful to have this possibility.
Example
We need only the days from monday to friday, within a daterange greater than x months.4 votes -
Mode Aggregate function with Time Series Insights
We have a requirement to aggregate data using MODE function ( returns the most occurring value from the given time range. Does Azure TSI supports this? Please suggest.
4 votes -
Timestamp documentation
The timestamp is an important factor in the Azure Time Series Insights. But there is no proper documentation regarding the format, the best practices to send timestamp in UTC (or in any other format) from the IoT device. It will be extremely helpful if there is proper documentation for this scenario.
4 votes -
Fix search span and interval misalignment issue in AggregateSeries queries
When aggregating data in TSI, you must provide an interval and a search span.
Sometimes the intervals start before the search span instead of at the specified "from" time. This also results in inconsistent number of intervals being returned.
e.g.
"aggregateSeries": {
"interval": "P1M",
"searchSpan": {
"from": "2020-11-01T00:00:00Z",
"to": "2020-12-31T23:59:59.999Z"
},
....}
TSI returned 3 intervals with timestamps:
- "2020-10-03T00:00:00Z"
- "2020-11-02T00:00:00Z"
- "2020-12-02T00:00:00Z"We expect 2 intervals with timestamps:
- "2020-11-01T00:00:00Z"
- "2020-12-01T00:00:00Z"
| |2 votes
- Don't see your idea?