Handling clock skew in field devices
- One minute read - 68 wordsField devices drift. Cheap RTCs lose minutes per month, and devices that lose power frequently come back with wildly wrong time. Trusting device timestamps makes time-series queries lie.
We correct at ingest: each batch carries a device sequence number, and we estimate offset against a monotonic counter. Measurements keep their relative ordering, and the corrected offset is stored alongside the raw value so the original is never lost.