Viewlatest RDBMS table data in Kibana

I have a small status table in Oracle which I would like to monitor in Kibana. I got the logstash setup with JDBC connection to my oracle and getting the data in elasticsearch index. How do I always show the latest snapshot of the table? Any suggestion will be appreciated. I am using version 6.5.4.

Sounds like you should be able to use the top hits aggregation in visualize.

That being said it kind of depends on the format of your data, could you provide an example?

Thanks Lukas for your response. I gave an attempt to use top hit but was not able to figure out how to show the table. Below is the example of my table structure which I am fetching from Oracle every minute

Untitled

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.