unsure if the right place for my question. In the Azure portal there are many tools for Analytics and Monitoring; however they all seem to be for server related metrics such as CPU usage, query times, etc.
I'm looking to write my own queries that query tables in my database and can send an email when such conditions are met. For example, say I had a table of credit card transactions, I'd want to write a select statement that calculates the 4-day moving average and sends a notification when over $1000.
I'm not seeing what tool/service in Azure portal can do this. I'd prefer to do it under the Azure toolkit and not a third party tool if possible (but open to suggestions). Thanks for the help!