Have you tried Azure Data Explorer? We look at how ADX can support large amounts of data and query at blazing fast speeds. it truly is BANANAS! And you can try it for FREE!
What is Azure Data Explorer?
Create a free Azure Data Explorer cluster
Azure Data Explorer (ADX) free cluster with Upgrade option