kafka-tutorials

kafka-tutorials copied to clipboard

In the ksqlDB timezone tutorial, a new stream is created with a timestamp configured to a specific timezone. Then, a connector sinks this stream to a Postgres DB.

The ability to view the timestamps in a different timezone in ksqlDB makes sense, but when sending this data to Postgres, as far as I understand, it’s just an epoch time being sent, and there’s no timezone information going to the DB. Only ksqlDB is aware of the timezone information. Is that correct? In other words, changing the timezone in ksqlDB isn’t really changing the underlying timestamp value in any way - it’s the same epoch time throughout.

If so, then it might be a good idea to add more narrative to the tutorial to explain this, to avoid any misunderstanding. The impression I got from the tutorial is that it's implying the timezone change made in ksqlDB is propagated to Postgres, but doesn't seem like it actually is.