Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,885 questions
4 answers
One of the answers was accepted by the question author.
Azure Analytics Query to group the date and events
We have a huge data of analytics from past few months & I am looking for a query to group the events in the order of date.
asked 2021-08-31T18:11:10.417+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Amrutha
21
Reputation points
commented 2021-09-15T20:43:23.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,381
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
How to fix azure.eventhub.exceptions.AuthenticationError: CBS Token authentication failed
I'm attempting to run a sample event generator to familiarize myself with Azure Event Hubs and Azure Stream Analytics. import asyncio from azure.eventhub.aio import EventHubProducerClient from azure.eventhub import EventData import json import…
asked 2023-02-26T03:27:04.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 93%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bill LaLonde
50
Reputation points
answered 2023-11-09T07:01:27.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 87%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mariyam Thomas
20
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS ETL Tool
Is the latest version of SSIS a fully cloud-based ETL tool?
asked 2021-02-05T20:37:45.827+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 35%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sridhar Vuligonda
21
Reputation points
accepted 2021-02-12T14:24:47.13+00:00
Sridhar Vuligonda
21
Reputation points
2 answers
One of the answers was accepted by the question author.
How to ingest CDC data from SQL DATA SYNC to Event hub?
Hi we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB. Which tools are good for near real-time processes and prices as well. By using data bricks we can merge stream data into delta lake. But How to ingest real-time…
asked 2020-11-10T12:28:43.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
THIMMAIAH GARI,PRASHANTH,,
201
Reputation points
edited an answer 2024-04-24T06:51:50.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shane Blake
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Stream Analytics Job - no output in SQL
Hello Team, i am facing with Stream Analytics Job with Output for SQL. I wrote a query and the output showing me the results which I expects. But somehow the results is not showing in my SQL table. I am running out of ideas. Not sure why it’s not…
asked 2023-11-01T18:52:40.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 46%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sutheswaran, Suwhathi
70
Reputation points
commented 2023-11-08T12:03:44.4766667+00:00
Sutheswaran, Suwhathi
70
Reputation points
2 answers
One of the answers was accepted by the question author.
If we schedule event hub capture with parquet and delta both in standard tier, will it be charged extra for more than one file format?
I am using Event Hub Standard Tier with 2 TUs with capture enabled. However when enabling capture in parquet, I use stream analytics job created to store same data in delta, json and csv as well. Since in Standard tier it is billed $73/TU/month. If I use…
asked 2023-07-28T07:45:23.76+00:00
Rishabh Tiwari
40
Reputation points
commented 2023-08-04T18:54:59.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Is capturing events in Parquet using stream analytics job costs extra on top of standard $73/TU/Month in Event Hub Standard Tier?
Hello People, I am working with Azure Event Hubs to pull data stream and capture it in Parquet format. Parquet is most suitable for my solution. I am using a standard tier Event Hub Namespace with 2 TU with capture enabled on Event Hub. As per the…
asked 2023-07-28T03:31:45.4533333+00:00
Rishabh Tiwari
40
Reputation points
accepted 2023-08-01T12:05:43.5733333+00:00
Rishabh Tiwari
40
Reputation points
2 answers
One of the answers was accepted by the question author.
Can Azure Stream Analytics Integrate with Azure App Configuration?
Can Azure Stream Analytics Integrate with Azure App Configuration?
asked 2023-04-11T15:16:20.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 28.000000000000004%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Amie Barkes
61
Reputation points
accepted 2023-04-12T08:45:23.75+00:00
Amie Barkes
61
Reputation points
2 answers
One of the answers was accepted by the question author.
Stream Analytics : Setting value for fixed variable in the query
Hi, So I have a AZ3166 device which I am using to connect with Azure Iot Hub and to Stream analytics. Currently, device is sending Temperature, Humidity and timestamp only. However, i need to define the Device ID in Stream analytics query for…
asked 2022-12-27T11:35:53.263+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUA%3C/text%3E%3C/svg%3E)
Umair Akhtar
41
Reputation points
answered 2022-12-30T07:36:39.25+00:00
Umair Akhtar
41
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure functions keep on running, inserting 10x values in Database
I have built a pipeline with Stream Analytics data triggering Azure Functions. There are 5000 values merged in a single data. I wrote a simple python program in the Function to validate the data, parse the bulk data, and save it in Cosmos DB as an…
asked 2022-10-23T04:13:21.483+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 83%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mohammad, Khaja Moinuddin
41
Reputation points
accepted 2022-11-04T18:28:21.893+00:00
Mohammad, Khaja Moinuddin
41
Reputation points
2 answers
One of the answers was accepted by the question author.
Data modification in log analytics before archiving it.
I have set up a connection between Azure DevOps and Log analytics workspace to get the audit data as a maintenance purpose. But before storing/archiving the data, I need to follow the GDPR rules i.e I have to remove the personal data before storing it…
asked 2022-10-12T09:41:20.623+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 4%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Abhishek Singh (Contractor)
21
Reputation points
accepted 2022-10-17T08:30:48.73+00:00
Abhishek Singh (Contractor)
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Not able to deploy ASA Edge Job as a module in IoT Edge Devices
I have created ASA Job as per sugeested in below microsoft document. here As per document when I tried to deploy my created ASA Job into IoT edge devices, Its giving and error that "The query provided is invalid for edge, Coudn't find all…
asked 2022-03-24T06:14:18.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 33%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Dhruv Harshadkumar Patel
26
Reputation points
commented 2022-04-19T04:38:51.537+00:00
Dhruv Harshadkumar Patel
26
Reputation points
2 answers
One of the answers was accepted by the question author.
System error (Duplicate property names) while running ASA job at IoT edge
Hello, I am trying to run the following query, but it shows the error as duplicate property name. However the names are different Questions: How can I name this property as I cannot use * for all selection? I am trying measure…
asked 2022-02-18T12:24:42.123+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
ankita m
66
Reputation points
answered 2022-02-18T18:02:50.14+00:00
Sander van de Velde
29,856
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Azure stream analytics on IoT edge Error: There is no input 'temperature'
Hello, I want to run Azure stream analytics job on Edge device. I followed the steps: tutorial-deploy-stream-analytics But I got an error while testing query : Input source is EdgeHub Output sink is EdgeHub
2 answers
One of the answers was accepted by the question author.
Azure Stream analytics job / Sql input issue
Hello, I try to create visualization with real time data in PowerBi using Azure Stream analytics job and getting data from azure sql database. I created input and output, connections passed tests correctly, now i try to match input with output with…
asked 2022-01-28T15:54:24.727+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gizinski, Artur (EXT - PL/Bydgoszcz)
21
Reputation points
answered 2022-02-04T12:37:32.577+00:00
Gizinski, Artur (EXT - PL/Bydgoszcz)
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Stream Analytics: SQL output and column order in SA query
Hi! I have a Stream Analytics query that sends data to several tables. Example: select node_info.timestamp_utc as timestamp_utc, node_info.node_name as node_name, props.battery_level as battery_level, …
asked 2021-10-27T18:37:21.197+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 55.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Jane Dickson
56
Reputation points
commented 2021-10-29T20:49:43.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
alexander.dimitrov
16
Reputation points
2 answers
One of the answers was accepted by the question author.
Az web app to visualize SQL Tables for multiple devices
Hi. We are trying to migrate to Azure our app which shows data from multiple IoT devices arranged in SQL tables. From what we read we believe the trick will be done with IoT Hub + Stream Analitics + SQL Az database +Az Web App. We hava many grey areas as…
asked 2021-09-10T18:50:22.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 95%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQI%3C/text%3E%3C/svg%3E)
QST Ingeniería
26
Reputation points
commented 2021-09-13T12:54:08.427+00:00
Alberto Morillo
33,086
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
error: not found: value EventHubsConf
Hi Everyone, I was trying to do some real-time stream analytics using databricks and azure event hub but I keep running into this error even when I have configured everything well. Here is the code snippet : import java.util._ import…
asked 2021-02-08T10:56:02.347+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 61%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
snehil singh
21
Reputation points
answered 2021-02-09T06:28:57.547+00:00
snehil singh
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Rest API Data stream to event hub
Hi Guys, We are using below rest api get method of accuweather to fetch location info curl --location --request GET 'http://dataservice.accuweather.com/locations/v1/adminareas/countryCode?apikey=VU86G' PostMan output: …
asked 2020-12-30T16:21:21.083+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 48%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dondapati, Navin
281
Reputation points
accepted 2021-01-05T16:07:01.147+00:00
Dondapati, Navin
281
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Powershell - Test Stream analytics job refererence input
Hi, I'm trying to test Stream analytics job inputs and outputs from Powershell (it is part of release pipeline). Everything is fine unless I come across an input of type "reference" (eg. SQL database). I'm using command…
asked 2020-09-23T10:03:53.897+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 41%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DeeplyGrow
21
Reputation points
commented 2020-09-29T00:25:22.967+00:00
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee