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.