Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,037 questions
I know how to do just over 100GB in the alert rules, but I don't know how to show the details, can you please tell me how to do this?
![](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, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN9%3C/text%3E%3C/svg%3E)
NishimuraChinatsu-9854
756
Reputation points
I would like to be alerted to the ID of a serverless 100+ GB query in synapse, with the data processed and the advocate.
I know how to do just over 100GB in the alert rules, but I don't know how to show the details, can you please tell me how to do this?
I am not using the alert rule, but logicapps is fine!
{count} votes
-
![](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(294.40000000000003, 87%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Mike Urnun 9,786 Reputation points Microsoft Employee2023-11-01T20:05:58.76+00:00 @NishimuraChinatsu-9854 I can help explore the possibilities with Logic Apps but I haven't used Synapse before. To confirm, you have a query in Synapse that yields 100+ GB of data, and when there's a matching ID in the resulting data, you want there to be an alert containing all the details of that record?
-
NishimuraChinatsu-9854 756 Reputation points
2023-11-02T00:38:51.3566667+00:00 Yes.
I would like to notify people who have used more than 100GB of queries, because some people cannot see the sql requests in synapse due to their permissions.
I don't plan to give them viewing privileges, so I would like to use azure monitor or logicapp to handle this.
But I don't know how to show the details. -
Mike Urnun 9,786 Reputation points Microsoft Employee
2023-11-09T22:23:06.62+00:00 @NishimuraChinatsu-9854 Thanks for providing additional info. I'll explore and share my findings with you.
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
Mike Urnun 9,786 Reputation points Microsoft Employee
2023-12-11T02:54:06.73+00:00 Hello @NishimuraChinatsu-9854 - Sorry for the late reply. To circle back, on the Logic Apps side of things, if there's ideally a REST API available for the data source, it's a great choice for using it to create the kind of notification workflow you described. For your use case of notifying people who used 100GB of data (from Synapse queries), I have yet to locate such REST API as I'm not too familiar with Synapse. Could you elaborate more on that part & share more details? If the data source can be polled or event-based, etc, to work as the trigger, the subsequent steps of creating the notification workflow should be pretty straightforward and effort-free in Logic Apps.
Sign in to comment