Announcing Saved Queries for Qubole Data Service

Start Free Trial
July 2, 2015 by Updated September 11th, 2021

We are always striving to add features to simplify the experience of our customers using Qubole Data Service (QDS). One of the major features 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 the 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 the 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 – the 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!

Start Free Trial
  • Blog Subscription

    Get the latest updates on all things big data.
  • Recent Posts

  • Categories

  • Events

    Data Lake & Data Warehouse – A Modern Data Strategy Discussion

    Oct. 22, 2021 | North America

    Get Technical With Qubole Solution Architects & Engineers

    Oct. 27, 2021 | Online

    Get Technical With Qubole Solution Architects & Engineers

    Nov. 10, 2021 | Online

    The Future of Data Science and Machine Learning at Enterprise Scale

    Nov. 12, 2021 | North America

    Open Data Science Conference

    Nov. 16, 2021 | North America - West

    Data Lake Vs Data Warehouse

    Nov. 17, 2021 | Middle East
  • Read NoSQL and Big Data: Is a NoSQL Database for You?
    nosql databases