Related to Microsoft Azure Cloud Analytics system
Find more information about Azure Stream Analytics:
Questions tagged [azure-stream-analytics]
919 questions
-1
votes
1 answer
Data processing architecture in Azure
A system is to be designed where a number of sensors will transmit data to event hub. Each sensor will transmit number of data(max 15-20 (around 5 KB)) each second.
One use case is that all of these raw data has to be transmitted to cosmosDB with…
Nabin Shahukhal
- 1
- 1
-1
votes
1 answer
Is it possible to detect the absence of related events based on given timout using azure stream analytics?
Say you have events telling you when given doors in a building are opened and closed and how long each door is allowed to remained opened before an alarm is triggered.
Something like: (might need a timestamp too on events...)
{ "id": 1,…
Oddleif
- 751
- 3
- 9
- 35
-1
votes
1 answer
Gzip Decompression not working as configured input in stream analytics job
I am sending compressed Gzip stream to IoT hub and forwarding it to Azure stream analytics as input. I have configured ASA input endpoint with compression type Gzip and serialization type JSON, but it fails with error Invalid compression and…
-1
votes
1 answer
Detect anomaly for string parameters using Azure Stream Analytics
I am working on anomaly detection using Azure Stream Analytics. I want to detect anomalies in request payloads passed to a Rest Api.
Azure Stream Analytics provides a built in function AnomalyDetection_SpikeAndDip, for detecting anomalies in the…
Deepak Tatyaji Ahire
- 4,883
- 2
- 13
- 35
-1
votes
1 answer
Manage Failover scenario for Azure Blob
I have a large soap xml file with at least 10000+ transactions, that is stored in an azure blob.
I am reading the xml content from azure and have to send individual transaction to the server for processing.
How can I manage the records that are read…
srikant_mantha
- 109
- 1
- 13
-1
votes
1 answer
stream analytics: Event processing delay, Performance Issues
I am facing some delay in event processing through stream analytics. I am working on an IoT Project and gateway is sending messages to IoTHub. Since we are dealing with different type of messages, through event hub end point we are routing the…
KingDileep
- 1
- 2
-1
votes
1 answer
Need to Store data into Azure Data lake Store using Azure Stream Analytics and IoT Hub: Data must be stored by 4MB buffer
I need to Store data into Aure Data lake Store using Azure Stream Analytics and IoT Hub. I configured my input and my output in Azure stream Analytics, and wrote my query:
SELECT * INTO [output-ADLS] FROM [inputForIotHub]
It works fine and get my…
T.Radius
- 43
- 1
- 7
-1
votes
1 answer
Have an requirement to verify the input (from eventhub) of stream analytics jobs for data quality
Is there a way to detect data quality issues from the streaming inputs (eventhub) (JSON) in Azure stream analytics?
Scenarios:
1) Bad messages: Blank records, NULLS/Spaces in key columns
2) values above expected Range, incorrect data type etc.
3)…
Mohan S
- 1
-1
votes
1 answer
Azure SQL can't handle incoming stream analytics data
I have a scenario where event hub gets data in every 10 seconds, which pass to the stream analytics and then which is passed to the Azure SQL Server. The technical team raised the concerns that Azure SQL is unable to handler so much of data, if data…
Hardik Shah
- 11
- 1
-1
votes
2 answers
Need help in T SQL query in Azure Stream Analytics
I am working in streaming of data by using Azure Stream analytics job which will use T SQL Query. I Have the following Requirement:
I can do it by using case and sum statements, but I have lot of countries and issues (L3), so is there any pivot…
Manoj
- 61
- 1
- 2
- 8
-1
votes
2 answers
Input data from multiple sources Azure streaming job
I need to send data from two devices to my Azure IOT hub.
Both of the devices transmit data with different JSON format. The common column between them is TimeStamp.
Now i need to consume and combine these two inputs and output my data into Power…
Prateek Raina
- 39
- 3
-1
votes
1 answer
azure stream analytics combine data with same time
I am working with azure stream analytics query language and i have some problems with data preparation.this is my current output
but i want to combine data with same time
for example in first line
{"46027020",…
s.kaiser
- 103
- 1
- 1
- 4
-1
votes
1 answer
Stream Analytics to PowerBI of different Account
I found some tutorials that show a Simple "Device Monitoring" solution using IoTHub -> StreamAnalytics -> PowerBI here and here.
Tried setting up the System as said just use a different Accounts for Azure (private MSDN account) and PowerBI (Work…
quadroid
- 8,444
- 6
- 49
- 82
-1
votes
2 answers
powerbi not refreshing in time
I am having the same issues with powerBI ,seems the automatic refresh its failing ,i currently have to click refresh to see new data coming in ,i have configure the the tumblingwindow part e.g tumblingwindow(second,3),done the live to dashboard are…
Hlatse
- 29
- 3
-2
votes
1 answer
What is meant by event i n azure event hub
I would like to know what is meant by an event in azure event hub.
I thought it's like getting some content(string) from source and process it by other services is one event.
if so, what is maximum content(string) I can send at one event
Saranraj K
- 412
- 1
- 7
- 19