We are playing with ASA and we just reach a certain point that we cannot go forward.
Our Scenario: EventHub -> Stream Analytics -> SQL Server
What we like to do: After receive some event, stream analytics should get the information, lookup on our sql server azure db some row, sum() and update back the sql server.
As far we know, ASA just uses SELECTs not UPDATEs.
Does anyone know how to do it?
You can look into using triggers to achieve this and have your ASA job write the event you're looking for to SQL database and the trigger will decide what to do (update, insert etc.) The SELECT statement inside and ASA query is to read data from inputs, the INTO clause defines where the result of the query will be stored.
Hope it helps, Thanks