Add sql as a data stream input with change data capture
It would be nice to support sql as a data stream input such that any rows added to a table are picked up and streamed, this allows realtime dashboard on existing applications without any recoding!
We are exploring the possibility of supporting CosmosDB change feed as ingress to Stream Analytics which will solve this scenario. For reference data, we already provide a mechanism to refresh reference data in Azure Blob storage using Azure Data Factory. More details about this here: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data
We are listening and committed to making Stream Analytics even better! Keep your feedback coming.
You could probably do this by creating a managed .NET assembly that runs form a trigger in your SQL database, and post events to a event-hub that the stream picks up....