Add support for querying latest ingested event timestamp

Add support for querying latest ingested event raw timestamp.
Useful for the knowing how much updated information realtime pipeline has specifically with high rollup granularity.
This has a race condition, I think… the compare-then-set doesn't appear to be synchronized on anything.