Incorrect Snowplow TZ value for obsolete zones
After updating snowplow library to v3 we see a number of misformed TZ values in os_timezone
field. An example
select * from prod.legacy.snowplow_unnested_events_30
where os_timezone = 'Asia/Calcutt' limit 10
List of TZs discovered so far:
'Asia/Calcutt', 'Asia/Rangoo', 'America/Buenos_Airesnos_Aires', 'Asia/SaigonMinh' THEN 'Asia/Ho_Chi_Minh'. All are obsolete/renamed.
Events are coming from old android devices mainly (although I havent checked all the TZ)
The library used fot determine TZ (by official snowplow tracker) https://github.com/pellepim/jstimezonedetect
Link to initial Slack thread: https://gitlab.slack.com/archives/CL3A7GFPF/p1680542100295189 (from 4-4-2023)
Edited by Niko Belokolodov