Azure data stores

I’m hoping to integrate Ignition with one of the Azure data store products as the historic data archive, has anyone done this before?

My fallback position is to use MS SQL in Azure but would like to use Azure Data Lake or Azure Data Explorer

We are able to flatten the mqtt payload data into ADX and use ignitions latest flattened historian feature for historian trends. Only caveat is that the ADX should hold a numeric continuously incrementing sequence id in it to make use of flattened historian feature.