Currently my system uses cosmos and sql db. What we do is perform our business functionality and store the outcome(huge Json file) to blob storage and then we pass this data based on filter criteria to downstream system.
The blob is getting bigger and bigger and its the same system used from long.
I am looking for new approach (more cloud focused azure) and thinking is mesh is better way to send data to downstream .
Need to modernize the current architecture .
I am thinking instead of adding a layer of blob, we can directly send data from cosmos and SQL on demand but I am worried of COSMOS RU cost .
I understand it is more subjective question and happy to delete if this does not meet criteria. Just wondering what is the best architecture to cater large data to downstream applications.