~/talk

Azure IoT from the edge to ADX

Talkat SQLBits 2023 · 2023-03-14..03-18· [iot, data-engineering]
slides:none on file

Shows an end-to-end Azure IoT pipeline: route device messages from IoT Hub into Event Hub (use 4 to 8 partitions for throughput), push into Azure Digital Twins for live state, and store history in Azure Data Explorer. Calls out must-do steps: enable streaming ingestion at cluster and database, use Stream Analytics to sample incoming JSON, create ADX table and a view/function to unwrap payloads, and set up continuous export every 2 minutes to Azure SQL. Demo mostly works with minor data-format hiccups.

AI-written summary · about

  1. 0:00Introduction to Azure IoT
  2. 1:25Message routing in IoT Hub
  3. 3:12Testing event hub routing
  4. 4:39Digital twin overview
  5. 5:41Azure Data Explorer basics
  6. 7:10ADX cluster setup and streaming
  7. 8:56Handling sensor data formats
  8. 11:52JSON parsing with views
  9. 13:19ADX for IoT analytics
  10. 14:43Summary and Q&A
~/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.