I am facing a problem. Suppose while tracking an event the device time is in different zone, collector is in different zone and my server is in different time zone.
If device is in IST and collector is in UTC and my server is in CDT. Now I am tracking events in some separate table as well where I am storing server time stamp which is in CDT. Now I want to join my event table with that other table using collector time stamp but i can not because both time stamps are different.
I am thinking to send server time as a separate parameter (say ttm) so that i can join my other event table with snowplow events table using ttm instead of collector time stamp. But I am not able to send ttm as parameter? Is there any way I can achieve this?