I have a bunch of sensors (currently 350) that are sending a total of around 500000 messages a day to an Azure IoT Hub. The sensors are grouped in to differently sized studies and i need to report on those studies each month.
I've tried to use stream analytics but couldn't find a way to dynamically route the messages to their respective locations. I dont want to have to add an individual output for each study.
Can anyone suggest a way to get these messages in to an Azure Data Lake so that each study's messages get put in their own folder eg \{StudyID}\{Year}\{Month}\[Message Data].