Azure Stream Analytics

Question

I was just wondering if we should just let the Stream Analytics running continuously so the data from the storage gets fed into out SQL database continuously (so every time new events get added onto the storage then the database gets automatically updated).

Also we are using a PowerShell script to upload the data from the B2C audit logs onto the Azure storage (https://learn.microsoft.com/en-us/azure/active-directory-b2c/view-audit-logs) and then are using Stream Analytics to get it into out SQL Database, that script would need to be executed hourly, would you be able to tell us what would be the best solution on Azure to execute that script every hour?

Answer 1

Hello anonymous user,

Welcome to the Microsoft Q&A platform.

Unfortunately, Azure Stream Analytics doesn’t support event-based triggers.

I would suggest you to vote up an idea submitted by another Azure customer.

https://feedback.azure.com/forums/270577-stream-analytics/suggestions/36754321-foresee-event-grid-output-for-azure-stream-analyti

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

You can use Azure Data Factory to create a trigger that runs a pipeline in response to an event.

This article describes the event-based triggers that you can create in your Data Factory pipelines.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.