From @nettrom_WMF:
Head’s up that the timestamp format in some schemas appears to have changed from e.g. 2021-02-24T00:57:39Z to e.g. 2021-02-25T00:54:21+0000
I’ve so far identified that this has happened with ServerSideAccountCreation, which is a server-side schema that was migrated last week (the format switch happens in the 14th hour of 2021-02-24, it looks the 15th partitions has the new format).
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 serversideaccountcreation WHERE year = 2021 AND month = 2 AND day = 24 AND hour IN(14, 15) ) SELECT dt, client_dt, schema, serverside_dt, id, uuid FROM ranked_events WHERE rnk <= 5
dt | client_dt | schema | serverside_dt | id | uuid |
---|---|---|---|---|---|
2021-02-24T14:59:53Z | NA | ServerSideAccountCreation | NA | NA | 9df7d97be5ee5d348dd67fa9e7f2be80 |
2021-02-24T14:59:52Z | NA | ServerSideAccountCreation | NA | NA | 6a29bf176edd58c99384f76e37c2ad03 |
2021-02-24T14:59:43Z | NA | ServerSideAccountCreation | NA | NA | 9b63480e51615ff9823cafcf8d74f5e9 |
2021-02-24T14:59:43Z | NA | ServerSideAccountCreation | NA | NA | 1fd61277dd505e91840a5351a5abeb65 |
2021-02-24T14:59:36Z | NA | ServerSideAccountCreation | NA | NA | 4e2f3ab655995fa6abe34726292d8178 |
2021-02-25T00:26:57+0900 | 2021-02-25T00:26:52+0900 | ServerSideAccountCreation | 2021-02-24T15:26:57.027Z | 6c0707b5-477d-458d-895b-f83ad059740b | NA |
2021-02-24T22:11:01+0700 | 2021-02-24T22:10:55+0700 | ServerSideAccountCreation | 2021-02-24T15:11:01.734Z | 2f0dbaa8-437b-40aa-a278-a4305f8155fd | NA |
2021-02-24T21:48:16+0600 | 2021-02-24T21:48:08+0600 | ServerSideAccountCreation | 2021-02-24T15:48:16.087Z | e5dd5671-8c35-4fc1-bcfc-6e988d3ec075 | NA |
2021-02-24T17:59:57+0200 | 2021-02-24T17:59:53+0200 | ServerSideAccountCreation | 2021-02-24T15:59:57.603Z | 556819ec-74ed-4bcc-a8a1-b0065a1a6bf6 | NA |
2021-02-24T17:56:15+0200 | 2021-02-24T17:56:09+0200 | ServerSideAccountCreation | 2021-02-24T15:56:15.780Z | 35c8f4eb-fb34-4b3a-b761-244561225ee7 | NA |