# Viewlatest RDBMS table data in Kibana
**URL:** https://discuss.elastic.co/t/viewlatest-rdbms-table-data-in-kibana/165124
**Category:** Kibana
**Created:** [January 21, 2019, 9:36pm UTC](https://discuss.elastic.co/t/viewlatest-rdbms-table-data-in-kibana/165124 "2019-01-21T21:36:52Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Swarnava\_Ganguly](https://discuss.elastic.co/u/Swarnava_Ganguly)
#### Post date: [January 21, 2019, 9:36pm UTC](https://discuss.elastic.co/t/viewlatest-rdbms-table-data-in-kibana/165124/1 "2019-01-21T21:36:52Z")
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.
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [January 22, 2019, 11:12pm UTC](https://discuss.elastic.co/t/viewlatest-rdbms-table-data-in-kibana/165124/2 "2019-01-22T23:12:58Z")
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?
---
### Author:  [@Swarnava\_Ganguly](https://discuss.elastic.co/u/Swarnava_Ganguly)
#### Post date: [January 22, 2019, 11:19pm UTC](https://discuss.elastic.co/t/viewlatest-rdbms-table-data-in-kibana/165124/3 "2019-01-22T23:19:50Z")
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
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 19, 2019, 11:19pm UTC](https://discuss.elastic.co/t/viewlatest-rdbms-table-data-in-kibana/165124/4 "2019-02-19T23:19:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.