Related to Microsoft Azure Cloud Analytics system
Find more information about Azure Stream Analytics:
Questions tagged [azure-stream-analytics]
919 questions
2
votes
1 answer
Azure Stream Analytics : remove duplicates while aggregating
I'm working on a system of temperature and pressure sensors, where my data is flowing through a Stream analytics job. Now there maybe duplicate messages sent in because of acknowledgements not being received and various other reasons. So my data…
user3740951
- 1,109
- 2
- 20
- 39
2
votes
1 answer
Azure stream analytics time window query
I am working on a project where we are recording temperature and humidity of multiple devices and on cloud side using Azure stream analytics to find if any device has breached it mentioned threshold limit.
We need to monitor device for 15 mins if…
Ravindra Saxena
- 21
- 2
2
votes
2 answers
Pivoting JSON Data Rows into Column
I need Help in Following.
I have data like
[{
"id": "0001",
"type": "donut",
"name": "Cake",
"topping":
[
{ "id": "5003", "type": "Chocolate" },
{ "id": "5004", "type": "Maple" }
]
}]
I want to Convert this into…
Sagar Malandkar
- 49
- 7
2
votes
2 answers
Can I add DeviceID in path while storing data from Azure Stream Analytics to Blob storage
I have Data incoming from Different devices to IoT hub from there using Stream Analytics to process it and store it in blob storage.
I know we can add {date}{time} we add in the path according to needed format, in that path can we add deviceId…
Amjath Khan
- 185
- 11
2
votes
1 answer
Azure Stream Analytics module on Iot Edge not reported by device after deployment
I created an ASA module and deployed it through Set Modules but on reported by device column is assigned NO.
What is the reason and meaning of this status after succesfull deployment and how can I fix it ?
These are my modules
and this is the Route…
gneric
- 3,457
- 1
- 17
- 30
2
votes
2 answers
What does rules engine mean in Stream Analytics on Azure?
I'm new to Azure and to analytics.
I'm trying to understand streaming alert rules engine. I have used some sample data as input and have queries to filter data.
However I'm not sure of what rules engine means, is it just queries or is there anything…
Nomad18
- 131
- 1
- 3
- 8
2
votes
1 answer
Azure Stream Analytics Job degrading while pushing data to cosmos DB
I Have data getting pushed from Azure IoT Hub -> Stream Analytics -> CosmosDB
I had 1 simulated device and my cosmos DB collection was of 1000 RU/s working fine .
now i have made it 10 simulated devices and my Cosmos DB collection scaled to 15000…
Amjath Khan
- 185
- 11
2
votes
0 answers
Azure Stream Analytics and Event Order
I am trying to set up a ASA job. My use case is that, I receive telemetry data from vehicles in the field. They transmit various attributes of the vehicle. e.g. Engine currently on or off
This data goes to IoT Hub and then ASA consumes it.
My…
Mnaseem
- 145
- 1
- 7
2
votes
1 answer
Filter line chart in Power BI with legends
I've an Azure Stream Analytics job that is constantly sending data to Power BI to show real time data.
This is a sample of my dataset:
[
{
"speed" :98.6,
"timestamp" :"2018-09-19T19:34:50.315Z",
"tag" :"AAAAA555555"
…
MAK
- 1,250
- 21
- 50
2
votes
1 answer
Azure Stream Analytics outputs an int64 as an int32
I have a Stream Analytics job that converts a timestamp into a number of milliseconds since Epoch.
To do this, I use a JavaScript function that returns a bigint, using the following code:
new Date(date).getTime()
When I test this job in the Azure…
Rodolphe
- 1,689
- 1
- 15
- 32
2
votes
1 answer
pass stream with array to multiple rows in SQL by Stream Analytics
I have a stream from IoT Hub like:
{
"topic": "saveData",
"deviceId": "testDevice",
"data": [
{
"timestamp": "2018-04-06T11:46:11.842305",
"device": "baiTest",
"variable": "Status01_Test",
…
eid
- 537
- 5
- 12
2
votes
2 answers
Azure Stream Analytics Pivoting Rows To Columns
I have a data like;
[
{"deviceid":"d1","parameter"="p1" value="1" timestamp="2018-03-22T12:33:00"},
{"deviceid":"d1","parameter"="p2" value="2" timestamp="2018-03-22T12:34:00"},
{"deviceid":"d1","parameter"="p2"…
Metehan Mutlu
- 127
- 10
2
votes
0 answers
Issue in renew-authorisation of stream analytics output for datalake store
I am trying to set up (deploy) a stream analytics job with data lake store as output using terraform. Terraform internally call the Azure API (through Azure Go SDK) for stream analytics to set the datalake store output that expects a refresh token.…
Afsal Thaj
- 93
- 5
2
votes
2 answers
Stream Analytics Job -> DataLake ouput
I want to set up CI/CD (ARM template) with StreamAnalytics Job with output set to DataLake Store.
https://learn.microsoft.com/en-us/azure/templates/microsoft.streamanalytics/streamingjobs/outputs#microsoftdatalakeaccounts
The issue comes with…
wolszakp
- 1,109
- 11
- 25
2
votes
2 answers
Azure Stream Analytics: Get Array Elements by name
I was wondering if it is possible for me to get the elements of the array by the name of property than the position. For example, this is my incoming data:
{
"salesdata": {
"productsbyzone": {
"zones": [{
…
user2263025
- 77
- 2
- 8