How to save a query in Dremio?

609 Views Asked by At

Dremio provides a really nice GUI to download and save data generated after your query run.

enter image description here

However, I want to save my query (instead of query result) in dremio so that I can anytime (in future) refer the query that I wrote. Is there a way to achieve this?

Really appreciate the help!

2

There are 2 best solutions below

4
On

In the left upper corner, you should look for Jobs menu:

enter image description here

0
On

Although this is an old post, I thought it might be helpful to provide a solution. What you are describing can be solved with a key functionality of Dremio. Instead of going through the difficulty of searching for your old query; I would have suggested creating a VDS (Virtual Data Set) by way of the UI. After a successful run of your query you can save it Dremio Save Dataset Button as a VDS.

After selecting the save button you will be asked where you wish to save it; you can either save it to your default directory or a named Space you have created previously Dremio VDS Save Dialog.

You can query against this new VDS as though it was an actual table. Any changes made to the VDS will be saved in a history - utilizing the breadcrumb trail on the right side of the UI one can navigate to prior versions.

You can now further accelerate this query through creation of a Dremio Reflection...but that goes beyond the scope of your question ;)