Stack Overflow
Stack Overflow

Questions tagged [azure-stream-analytics]

Related to Microsoft Azure Cloud Analytics system

Find more information about Azure Stream Analytics:

919 questions
2
votes
1 answer

How can i count all azure EventHub events of the current day using StreamAnalitics each 5 minutes?

I need to count all events collected during the current day, from 0:00 to 23:59 utc time each five minutes. I'm using a stream analytics service withe the current query: SELECT Cast(pid as bigint) as PublisherID,Cast(cid as bigint) as CampaignID,…
Riccardo
  • 180
  • 1
  • 12
2
votes
0 answers

Get REST API response (String Array) into Azure Stream Analytics

Hello Stack Overflow community members. Can anyone recomend an approach to do the following within MS Azure standard service scope: 1. Call external REST API; 2. Get REST API response (that is string array) into Azure Stream Analytics (ASA) for…
VSV
  • 21
  • 3
2
votes
1 answer

Azure Stream Analytics: "Output contains multiple rows …" warning

we're using a Stream Analytics component in Azure to send data (log messages from different web apps) to a table storage account. The messages are retrieved from an Event Hub, but I think this doesn't matter here. Within the Stream Analytics…
Onkel Toob
  • 2,152
  • 1
  • 17
  • 25
2
votes
2 answers

Azure Stream Analytics CreateOrReplace Transformation Conflict or Bad Request

We are currently streaming data from an Azure Event Hub via Azure Stream Analytics to Cosmos DB. I want to be able to programatically change the query (/ Transformation) that is completed as the data is streamed. var existingQuery =…
DanAdrenaline
  • 23
  • 4
2
votes
3 answers

azure stream analytics to cosmos db

I have a trouble saving telemetry that are coming from Azure IoT hub to Cosmos DB. I have the following setup: IoT Hub - for events aggregation Azure Stream Analytics - for event stream processing Cosmos DB with Table API. Here I created 1…
Ihor Korotenko
  • 846
  • 1
  • 13
  • 29
2
votes
1 answer

How to retrieve azure iot-hub storage account name

I am writing a PowerShell script that creates iot-hub account with storage account and a streamAnalytics job. For updating the json file for the streamAnalytics job, I need to retrieve the storage account name that has just been created.…
N.avraham
  • 333
  • 2
  • 15
2
votes
1 answer

Creating Azure Stream Analytics Job through Powershell

I would like to create a stream analytics job using only Powershell. I know that the command to do this is: New-AzureRMStreamAnalyticsInput. However it requires a JSON file with job details. I found a documentation provided by Microsoft where there…
p0l00ck
  • 186
  • 3
  • 15
2
votes
2 answers

Is it possible to Upsert using Stream Analytics

I am using Stream Analytics to insert data into table storage. This works when all I want to do is add new rows. However, I now want to insert or update existing rows. Is this possible with Stream Analytics/Table storage?
Slicc
  • 3,217
  • 7
  • 35
  • 70
2
votes
2 answers

Azure Stream Analytics -> how much control over path prefix do I really have?

I'd like to set the prefix based on some of the data coming from event hub. My data is something like: {"id":"1234",...} I'd like to write a blob prefix that is something like: foo/{id}/guid.... Ultimately I'd like to have one blob for each id. This…
Chris
  • 169
  • 1
  • 2
  • 14
2
votes
1 answer

Azure Stream Analytics - Compare if current event temperature level is same with previous event temperature level

I have sending device temperature and humidity value from downstream and having one ASA for handling value either under alert or normal status for sinking into Event Hub. The device is sending Temperature and Humidity information that contains its…
Luiey
  • 843
  • 2
  • 23
  • 50
2
votes
1 answer

Stream Analytics: Dynamic output path based on message payload

I am working on an IoT analytics solution which consumes Avro formatted messages fired at an Azure IoT Hub and (hopefully) uses Stream Analytics to store messages in Data Lake and blob storage. A key requirement is the Avro containers must appear…
Pete M
  • 2,008
  • 11
  • 17
2
votes
1 answer

Azure Stream Analytics - Reference Blob not found

I am having a hard time setting up Stream Analytics to use a reference Blob. I have Data factory moving a table from SQL table to a CSV file in a blob container. I did try the data/time method but could not get that to work at all coming up with the…
BrentA
  • 172
  • 8
2
votes
3 answers

Is there a way to backup or export Azure IOT components?

I've got a large Azure IOT Suite implementation and I'd like to back it up or export the various jobs/components for safe keeping. We had a few instances where someone deleted something incorrectly and it took some time to recreate it. Thanks! …
Nick
  • 99
  • 7
2
votes
2 answers

Power BI Embedded use of Azure Stream analytics

Does anyone know is there a way of using Azure Stream Analytics job as a source for Power BI Embedded report? There is other Azure data sources available, but no ASA on Power BI Desktop, while designing the Power BI report.
Jorma Pulkkinen
  • 21
  • 1
2
votes
1 answer

Streaming Application Insights 'availability' telemetry to SQL

I can't seem to get Availability telemetry pushed to a Azure SQL DB using Stream Analytics. There is NO error. It's just that no data is inserted. Input I have the input set up to the blob location where Application Insights exports too. I have…
Dave New
  • 38,496
  • 59
  • 215
  • 394
1 2 3
…
61 62