I am developing an historical information endpoint, so the user can select a device id and see when it was online/offline (daily). So, I would like to select all the events with the same key between two dates from a Kafka topic in ksqlDB without emitting changes. I find the “tumbling window pull query” feature (kind of) similar, but it seems to me that it is only for aggregated data.
Which feature should I use?
Here is a simplified example of the data that I am using:
CREATE STREAM gateway_connections_daily ( gatewayid VARCHAR KEY, connection VARCHAR ) WITH ( kafka_topic='gateway.fct.connection.0', value_format='JSON' );
Thanks for all in advance.