Sequence of snowplow component time stamps in bigquery database

Device created timestamp depends on the devices clock. The other timestamps are the clocks on your servers. So we can’t really expect them to be in sync.

Here’s a good article to read on the subject of Snowplow’s measurement of time.

2 Likes