Query Gallery in Google Sheets Add-on

When you need to reuse the same query in multiple Google Sheets workbooks, or just want to store it somewhere for future use, you can save your query to the Skyvia Query Gallery. These saved queries are stored on the Skyvia service (not in Google Sheets), and are available both from Skyvia and from Skyvia Query Google Sheets Add-on.

In addition to your own queries, Query Gallery stores a number of predefined public queries to different data sources.

query-add-on-gallery-sources

ExpandedToggleIcon        Saving Query for Future Use

To save your query for future use, perform the following actions:

1.Click Save in the Query Editor. If you use an already saved query, you may then click Save to overwrite it or Save As - to save the current query under a new name.
 
query-add-on-save-as
2.Enter the name of the query to the Name box.
 
query-add-on-save
3.Optionally select an existing folder in the Folder list. You can create, rename and delete folders on Skyvia, in the Query Gallery.
 

note Note

Skyvia does not allow creating nested folders for storing queries, it allows using only one-level folder structure for storing queries

4.Optionally specify a description for the query in the Description box.

 

ExpandedToggleIcon        Query Gallery User Interface Elements

The topmost Query Gallery part contains four tabs: Sources, Connections, Folders, and Queries. These tabs group the stored queries by different criteria. These tabs are described below.

Under the tabs, there is the Query Gallery header, which shows, what exactly is currently displayed in the Query Gallery, and contains a toggle button to show or hide public queries. When Query Gallery displays the list of queries, header also contains the Search box, which allows you to quickly find a query in the list by typing a part of its name.

Under the header, Query Gallery can display different lists, depending on the tab opened.

 

ExpandedToggleIcon        Query Gallery Tabs

Sources Tab

Sources tab groups the stored queries by data source they query data from. When you open this tab, it displays the list of the data sources, for which there are stored queries in the gallery. After you click a data source, it displays the list of the queries for the clicked data source. The list header will display the data source you have clicked.

To navigate back to the list of data sources, click the query-icon-less button in the connection header.

Connections Tab

Connections tab groups the stored queries by connections they use. When you open this tab, it displays the list of the connections, for which there are stored queries in the gallery. After you click a connection, it displays the list of the queries for the clicked connection. The list header will display the name of the connection you have clicked.

To navigate back to the list of data sources, click the query-icon-less button in the connection header.

note Note

The Connections tab does not display queries saved without the connection information (with the Save connection reference check box not selected). You can open such queries via other tabs.

Folders Tab

This tab groups queries by user-defined folders. First it displays the list of the folders, and after you click a folder, it displays the list of the queries stored in this folder. The list header will display the name of the folder you have clicked.

To navigate back to the list of data sources, click the query-icon-less button in the connection header.

note Note

The Folder tab does not display queries saved without specifying a folder. You can open such queries via other tabs.

Queries Tab

This tab displays a list of all the stored queries without grouping.

 

ExpandedToggleIcon        Query List

The Queries tab displays the list of queries immediately. On other Query Gallery tabs you need to click a data source, connection, or folder, depending on the tab.

query-add-on-gallery-queries

You can enter a part of a query name to the Search box to quickly find the necessary query.

Click a query in the list to display its details in the gallery.

 

ExpandedToggleIcon        Running, Editing, or Deleting Queries

When you open a query in the Gallery, Skyvia displays its name, description, and connection. Skyvia also displays the query parameters, if any, allowing you to configure their types and set their values without opening the query in the query editor.

You can select another connection for your query in the Connection drop-down list, run the query, open it for editing, or delete it from the Gallery by clicking Run, Edit, or Delete button, respectively, at the bottom of the Gallery.

You can also open it on Skyvia by clicking the query-add-on-open-on-skyvia Open Query in Skyvia button in the Gallery header.

query-add-on-gallery-query

 

 

ExpandedToggleIcon        Public Queries

Skyvia offers a number of predefined public queries in the Query Gallery. Our professionals have selected a number of useful queries for most common use cases for different data sources. You can use these queries immediately or create your own queries, using them as templates. Additionally you can study some aspects of the SQL language on these queries.

Public queries are available for all Query users, and they have some specific features:

1.They cannot be deleted from the Query Gallery. If they obstruct finding your own queries, you can simply hide them by clicking the toggle in the Query Gallery header. Click this toggle once more to display them again.
2.Public queries are not linked with a specific connection. You will need to select a connection manually for them. They also are not placed to any of your folders if you have some. This means, public queries are displayed neither on the Connections tab nor on the Folders tab. You can access them only on the Sources or Queries tabs of the Query Gallery.