I'm preparing proof of concept for azure iot . I send data from device a to azure iot hub and from iot hub sending data to database via stream analytics.
Question is : I want to check if I have this record in database if not I want to add record. And I want to create "start time" when some certain event occurred and "finish time" event is finished so I need to update row. Is it possible with stream analytics and is stream analytics correct place to do this kind of checks ?