Sequence of snowplow component time stamps in bigquery database

[siv]

Hey,

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!

[Colm]

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.

[siv]

Okay, Got it

Thank you @Colm