Query Gallery

Skyvia allows saving created queries for future use in the Query Gallery. In addition to your own queries, Query Gallery stores a number of predefined public queries to different data sources.

query-gallery-sources

ExpandedToggleIcon        Query Gallery User Interface Elements

The topmost Query Gallery part contains four tabs: Sources, Connections, Folders, and All 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.

This tab also allows you to rename and delete your folders. To rename a folder, point to it in the folder list, then click the query-icon-rename Rename Folder button. After this edit the folder name and then click query-icon-apply-rename Apply rename. To delete a folder, point to it in the folder list, then click the query-icon-delete Delete Folder button.

note Note

When you delete a folder, all the queries, stored in it, are deleted!

note Note

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

All Queries Tab

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

 

ExpandedToggleIcon        Query List

The All 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-gallery-query-list

The following information is displayed for each query in the query list:

The icon of the queried data source;
Query name and description;
The dates the query was created or last modified on;
Whether the query is public or private;
Type of the query result: It can be table (for queries, returning grid with data), or line, area, column, bar, or pie (for queries, returning the corresponding chart. Result type can easily be changed later. See the Viewing Data in Table View and Creating Charts topics for more information.

 

Opening or Deleting Queries

When you point a query in the list, a buttons for performing actions with the query are displayed. With these buttons you can open or delete queries in the list.

To open a query, simply click it. Or you can open it in a new tab by pointing to it and then clicking the query-icon-open Open in a new tab button. To open a query and immediately run it, point to it and then click the query-icon-run Open in new tab and run button.

To delete a stored query by pointing to a query and clicking the query-icon-delete Delete query button.

note Note

Public queries cannot be deleted.

 

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 All Queries tabs of the Query Gallery.