~/talk

Stop waiting to explore your data: use Azure Data Explorer!

Talkat SQLBits 2020 · 2020-09-29..10-04· [data-engineering]
links:none on file
slides:none on file

Azure Data Explorer handles streaming raw data for quick analysis: demoed a taxi trips dataset of 1.5 billion rows and runs a monthly aggregation in 25.05 seconds. It ingests from Event Hub, Blob, Data Factory or push/pull methods, supports Kusto Query Language, external tables over JSON, built-in time-series forecasting, pivots and dashboards (preview). The cluster+database model auto-manages indexing, offers compute- or storage-optimized SKUs, and the demo queries, charts and forecasts all execute successfully.

AI-written summary · about

  1. 0:00Introduction
  2. 0:59Why Azure Data Explorer
  3. 6:25What is Data Explorer
  4. 10:42Use cases
  5. 17:50How can it be used
  6. 21:30User Interfaces
  7. 26:30Query Structure
  8. 29:25Operator explain
  9. 31:25Pricing
  10. 32:54Demo
  11. 36:10Charts
  12. 40:00Time charts
  13. 41:23Correlation
  14. 42:50Forecasting
  15. 43:43Pivot Tables
  16. 45:37External Tables
  17. 48:11Query Results
  18. 51:06Functions
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.