Sequence of snowplow component time stamps in bigquery database


I have the complete snowplow pipeline setup in one region on Google Cloud Platform.
My tracker device is also in the same time zone.

I assumed that the order of time stamps should be dvce_created_tstamp,collector_tstamp, and then etl_tstamp.

The data in the BQ says different, is there something I’m missing?

Thank you!

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.


Okay, Got it

Thank you @Colm