The format of dt in client-side EventLogging schemas changed after migration to include millisecond precision. Here's a recent example from the migration of EditAttemptStep in T267343:
Run on https://superset.wikimedia.org/superset/sqllab:
WITH ranked_events AS ( SELECT dt, client_dt, schema, meta.dt AS serverside_dt, meta.id, uuid, RANK() OVER (PARTITION BY hour ORDER BY dt DESC) AS rnk FROM event.editattemptstep WHERE year = 2021 AND month = 3 AND day = 8 AND hour IN(20, 21) ) SELECT dt, client_dt, schema, serverside_dt, id, uuid FROM ranked_events WHERE rnk <= 5
dt | client_dt | schema | serverside_dt | id | uuid |
---|---|---|---|---|---|
2021-03-08T20:59:59Z | EditAttemptStep | 14fd8bc5da7c577d83f150256294fa22 | |||
2021-03-08T20:59:59Z | EditAttemptStep | 3ec891312b015007b1a4ddaa57ac2dad | |||
2021-03-08T20:59:59Z | EditAttemptStep | 8b79cd562d0f5c70a5ee5edf947ede4a | |||
2021-03-08T20:59:58Z | EditAttemptStep | ceafeb50ad8a5ba09d0c87bd527bc572 | |||
2021-03-08T20:59:58Z | EditAttemptStep | 43573c9a473d5eada62cde7f6dff7a35 | |||
2021-03-08T20:59:58Z | EditAttemptStep | 37bddd6f9f995dd5bf4d43b58f596f45 | |||
2021-03-08T20:59:58Z | EditAttemptStep | 0e28daf0b1465809a051aa3933cb983f | |||
2021-03-08T20:59:58Z | EditAttemptStep | 67792ae611455f9eb867f8ca2ec86b57 | |||
2021-03-08T20:59:58Z | EditAttemptStep | 7cc87007fd865d9ea9922e269df88ab2 | |||
2021-03-09T21:27:22.975Z | 2021-03-09T21:27:22.975Z | EditAttemptStep | 2021-03-08T21:27:07.897Z | 985ee03e-92df-4dfe-8cd7-8bf69ad851c7 | |
2021-03-09T21:27:18.120Z | 2021-03-09T21:27:18.120Z | EditAttemptStep | 2021-03-08T21:27:07.897Z | 2581fb75-e5ee-48b9-98c1-63b3225a2474 | |
2021-03-09T21:27:18.119Z | 2021-03-09T21:27:18.119Z | EditAttemptStep | 2021-03-08T21:27:07.897Z | 5f52c868-501e-4cdc-b1ab-328dda81f353 | |
2021-03-09T21:27:17.814Z | 2021-03-09T21:27:17.814Z | EditAttemptStep | 2021-03-08T21:27:07.895Z | 7ac7e503-67af-404e-bb4e-56b4fddefe16 | |
2021-03-09T09:37:36.477Z | 2021-03-09T09:37:36.477Z | EditAttemptStep | 2021-03-08T21:41:31.208Z | ff5ff12e-105f-455b-8b43-f20cd95be5db |