• Home... >
  • Blog >
  • Announcing Saved Queries for Qubole Data Service

Blog

 
 
 

Announcing Saved Queries for Qubole Data Service

  • By Raghunandan Balachandran
  • July 2, 2015
 

We are always striving to add features to simplify the experience of our customers using Qubole Data Service (QDS). One of the major feature asks which has come up time and again is the ability to design queries and save them in a design time repository. This concept would allow separation of design time artifacts from runtime and would allow developers to manage their query and command definitions as a first class object in QDS. We are very happy to announce that we now support this functionality with Saved Queries!

The major features of Saved Queries are listed below:

  • CRUD (Create, Read, Update, Delete) operations
  • Assign unique names to Saved Queries
  • Execute Saved Queries and see history of all the runs
  • Configure version control for Saved Queries

It’s easy to try out Saved Queries. Within the Analyze tab of QDS, save a query by clicking on the Save button in the composer window as shown below:

saved_queries_4

Provide a unique name for the query.

saved_queries_2

The Repo tab within Analyze shows all Saved Queries created by the user.

saved_queries_1

Select a query from the list and run. For the query you selected, all runs of that Saved Query will be listed in the Commands tab. This gives you the full execution history for that Saved Query.

saved_queries_3

While on the Repo tab users can edit the Saved Query and save it again. The Versions tab shows all edits that have happened on the query in chronological order – latest being first.

saved_queries_5

Future work

We would love to hear feedback from you on this feature to shape its future. On our side we have identified some ideas for future work, such as the ability to templatize Saved Queries and the ability to schedule Saved Queries. Let us know what you think!


Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? *

 
 
 
 
clear