Azure Data Explorer succeeds because it indexes aggressively at ingest so it can ignore aggressively at query. When you "read online" in ADX, you aren't reading the data. You are reading the index of the index .
There is a forgotten middle child in the Azure analytics stack. Everyone talks about Synapse for data warehousing and Stream Analytics for ingestion. Few talk about the silent workhorse: — formerly known as Kusto.
If you are serious about scalable data analytics, you need to stop thinking like a database administrator and start thinking like a . The "Read Online" Epiphany Let’s talk about that phrase: "scalable data analytics with azure data explorer read online."
Scalability is not about how much data you can store . It’s about how much data you can forget —while still answering the question.
If you haven't spent a weekend ingesting a billion log lines into ADX and running a summarize across them in under two seconds, you haven't yet understood what "scalable" actually means.
Stop scanning. Start seeking.
English