# Is it possible to show mysql query result in Data Table Visualization?

**URL:** https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001
**Category:** Kibana
**Created:** [November 9, 2017, 9:23am UTC](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001 "2017-11-09T09:23:32Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![saafianihan](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@saafianihan](https://discuss.elastic.co/u/saafianihan)
#### Post date: [November 9, 2017, 9:23am UTC](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001/1 "2017-11-09T09:23:32Z")

</div>

I have to show mysql query result in kibana Data Table Visualization without changing or grouping the fields or columns. Data Table should be the replica of Query Result. Is it possible?

---

<div class="post-metadata">

### Author: ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [November 9, 2017, 9:51pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001/2 "2017-11-09T21:51:27Z")

</div>

Hi Saafia, before you can visualize your MySQL data in Kibana, you will need to migrate your data from MySQL into Elasticsearch.

- Here is [another Discuss thread](https://discuss.elastic.co/t/kibana-mysql-connection/17949/2) which outlines this process.
- In that thread, they refer to the [Jdbc Logstash plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) as the mechanism for migrating your data from MySQL to Logstash.
- I did some Googling and also found [this tutorial and video](http://datascience-enthusiast.com/Miscellaneous/MySQL_to_ELK.html) which dives into this process and may or may not provide you with some insight.

Once your data is in Elasticsearch, I can help you figure out how you want to display it in a Data Table and how to configure your visualization to reach your goal. I hope this helps!

Thanks,  
CJ

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 7, 2017, 9:51pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001/3 "2017-12-07T21:51:49Z")

</div>

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