# How to port dev tool queries to into the dashboard?

**URL:** <https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678>\
**Category:** Kibana\
**Created:** [June 5, 2018, 6:51pm UTC](https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678 "2018-06-05T18:51:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gthang](https://avatars.discourse-cdn.com/v4/letter/g/258eb7/32.png) [@gthang](https://discuss.elastic.co/u/gthang)\
**Post date:** [June 5, 2018, 6:51pm UTC](https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678/1 "2018-06-05T18:51:03Z")

</div>

We are about to onboard Elasticsearch + Kibana in our environment. That said, I have been using Kibana dev tools to run queries and I have gotten a pretty good feel for it now.

Now that I have gotten past that hurdle, I am looking at producing data as tables or charts using Kibana and I am getting stumped in translating some of these queries over from "Dev Tools" into the "Dashboard".

A few searches that I did tells me that, this is not possible, but this is from some time back. Has anything changed since then?

It seems like a real PITA to port queries over, can somebody share their thoughts on this matter?

Thanks,  
g

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [June 5, 2018, 7:10pm UTC](https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678/2 "2018-06-05T19:10:40Z")

</div>

Hey @gthang, we have two options here, the first and most common approach is to use the Visualize editor to create your Visualizations, but if you go this route there isn't a way to directly grab a query and create a Visualization from it. Instead, you'll have to use the Visualization Editor to create the necessary aggregations/metrics using the UI to create the different Visualizations.

The second options, which is less common but more powerful, is to use the [Vega](https://www.youtube.com/watch?v=lQGCipY3th8) visualization which lets you use your existing queries directly to build various charts/graphs.

---

<div class="post-metadata">

**Author:** ![gthang](https://avatars.discourse-cdn.com/v4/letter/g/258eb7/32.png) [@gthang](https://discuss.elastic.co/u/gthang)\
**Post date:** [June 6, 2018, 2:38pm UTC](https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678/3 "2018-06-06T14:38:23Z")

</div>

Hello Brandon,

Thanks for your response, do you have any idea when the SQL functionality is going to be pushed out into elastic.

I was looking at this [link](https://www.elastic.co/elasticon/conf/2018/sf/elasticsearch-sql) specifically.

Thanks,  
gthang

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [June 6, 2018, 2:53pm UTC](https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678/4 "2018-06-06T14:53:02Z")

</div>

@gthang there's nothing definitive yet, but our Canvas plugin [https://www.elastic.co/blog/canvas-tech-preview](https://www.elastic.co/blog/canvas-tech-preview) is most likely the first thing that will get support for SQL, but it's something that we want to incorporate in a more comprehensive manner long-term.

---

<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:** [July 4, 2018, 2:53pm UTC](https://discuss.elastic.co/t/how-to-port-dev-tool-queries-to-into-the-dashboard/134678/5 "2018-07-04T14:53:15Z")

</div>

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