Ability to use more than one source for reference data
It would be nice to be able to use "reference" data from more than one source. I've aware that the possibility of using SQL table and Storage table is under consideration but this is different.
Usage scenario for an IoT application: you have inbound sensor data that you need to process. You have reference data (such as thresholds that are different for each sensor) and you have customer configurations that you need to check against the incoming data.
Some of that data might be stored in a SQL table and other on Storage or is updated in Blob storage.
In the current approach you can only use Blob for reference data AND you are VERY limited in the size of the reference data file.
Even if you use Azure data factory to gather data from all those sources and combine it into that blob file, the limite size is easily reached with some thousand devices. Considering that this is targeting IoT use scenarios you just can't use reference data because you can't generate a reference file with simple data pair such as (deviceID;thresholdValue) fit into an usable Blob.