1. User’s Guide
  2. Using Oracle Big Data SQL for Data Access
  3. Oracle SQL Access to Kafka
  4. Exploring Kafka Data from a Specific Timestamp

2.4.8 Exploring Kafka Data from a Specific Timestamp

In addition to reading records from a specific offset, Oracle SQL Access to Kafka (OSaK) allows you to position an OSaK view to start at a particular timestamp and read messages in a user defined window of time. As compared to ORA_KAFKA.SEEK_OFFSET which is restricted to OSaK views that map to only one Kafka topic/partition, ORA_KAFKA.SEEK_OFFSET_TS can be used on any OSaK view. The ORA_KAFKA.SEEK_OFFSET_TS procedure is used to specify a window of time for an OSaK view.