Saved Queries
  • 18 Aug 2021
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Saved Queries

  • Dark
    Light
  • PDF

Overview

All queries that are saved in SQL Editor will appear in the Saved Queries screen.

From there, you have access to a variety of features that enable you to manage and work with your saved queries, such as:

  • View, edit, and delete saved queries
  • Copy a URL for the saved query
  • Bulk delete and export saved queries

Let's look at saved queries in more detail below.


In the Toolbar, select SQL Lab and, in the drop-down menu, select Saved Queries.

Select_Saved_Queries


Interface

Interface_Saved_Queries(1)

Column Header Description
Name The name of the saved query.
Database The database associated with the saved query.
Schema The schema associated with the saved query, if applicable.
Tables The table/dataset associated with the saved query.
Created on How long ago the query was saved.
Modified How long ago the query was last modified.
Actions See below.

Query Search and Filter

To narrow down saved queries, you can use the Database and/or Schema filters. Additionally, saved queries can be searched using the Search field.

Query_Search_and_Filter


Add a Query

To create a new query, select + Query.

Add_a_Query

The SQL Editor page appears featuring a new blank untitled query.

New_Blank_Query


Actions Column

To view available actions for a saved query, hover your cursor over a query row under the Actions column header.

Query Preview

To view a preview of your saved query, select the Query preview binoculars icon.

Query_Preview

The Query preview panel appears.

Query_Preview_Panel

Feature Description
Copy icon This icon appears when you hover your cursor over the query text. Select the copy icon to copy the query text to your system's clipboard.
Previous View the previous saved query from the list of saved queries.
Next View the next saved query from the list of saved queries.
Open in SQL Lab Launches the saved query in the SQL Editor.

Edit Query

To edit your saved query, select the Edit query pencil icon.

Edit_Query2

The saved query will be launched in the SQL Editor for editing.

When done making any changes, select Save.

Edit_Query2a

Copy Query URL

To copy a URL of your saved query, select Copy query URL.

A notification message will appear confirming the URL copy. This URL launches the SQL Editor featuring your saved query.

Copy_Query_URL

Export Query

To export a saved query, select Export query.

Your system will download the saved query in ZIP archive file format.

Export_Query

Delete Query

To delete a saved query, select the Delete query trash bin icon.

Delete_Query

The Delete Query? panel appears.

To confirm deletion of the saved query, type "DELETE" in the text-entry field and then select Delete.

Delete_Query1


Bulk Actions

Using Bulk Select

The Bulk Select tool enables users to delete or export multiple saved queries.

Let's see how it works.

Start by selecting Bulk Select.

Bulk_Delete1(1)

Select multiple checkboxes for each saved query or, to select all queries, select the checkbox in the header column.

In the example below, we selected two queries.

Bulk_Select1

Bulk Deletion

To delete both queries, select Delete.

Bulk_Delete2(1)

The Please confirm panel appears.

To confirm the deletion, enter the word "DELETE" in the text-entry field and then select Delete.

Bulk_Deletion_Confirmation

Bulk Export

To export both queries, select Export.

The saved queries will be archived together in a ZIP format and a download will commence.

Bulk_Export


Was this article helpful?

What's Next