Query Gallery

Query Gallery helps you to automate most common query tasks using predefined templates in just a few clicks. These templates are known as public queries, and Skyvia provides a wide range of them to different data sources. Almost all your needs in data querying will be covered securely — simply choose the required public query from the available list. To open the list of queries, click the Sources List icon icon.

Sources List

In addition, you can create your own queries in Query Gallery and save them for future use. Queries can be as simple or as complex as you need.

How to Save Queries for Future Use

If you have created a useful query and want to reuse it in future, you can save it in the Query Gallery. For this, perform the following steps:

  1. Click Save on the Query page toolbar.
  2. Enter the name of the query in the Name box.
  3. Optionally specify a description for the query in the Description box.
  4. Optionally clear the Save connection reference check box if you want to store query without binding it to a specific connection. In this case you will need to select a connection for it again after you open it from the Query Gallery.

    Save Query window

When you save a query in the gallery, all the query settings are saved, including changes made in the query builder, SQL statement, etc.

You can open or delete a saved query later in the Query Gallery or in the OBJECTS list.

As well as other Skyvia objects, saved queries are available in the OBJECTS list, and you can manage them as well as other Skyvia objects. You can organize them into folders, edit or delete them, filter by name or data source, etc. To switch to the OBJECTS list, click OBJECTS in the top menu and select the Queries tab.

Object list

How to Quickly Find the Needed Query

If you want to quickly find a query that you previously saved for future use in the Gallery, you can do it in the following way:

  1. Hide predefined public queries by clicking the toggle in the Query Gallery header.

    Query Gallery toggle

  2. Click the data source you have created a query for.
  3. If you have many queries for this data source, enter a part of the query name to the Search box.
  4. To open a query, simply click it. Or you can open it in a new tab by pointing to it and then clicking the Open in a new tab Open in a new tab icon. To open a query and immediately run it, point to it and then click the Open in a new tab and Execute Open in new tab and Execute icon.

Or you can simply click the All Queries tab and enter part of the query name to the Search box. Keep on searching until you find the necessary query.

If you organized your queries in folders, it may be quicker to switch to the Folders tab and find the necessary folder with your query in it.

How to Open or Delete Queries

When you point to a query in the list, 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 Open in a new tab Open in a new tab icon. To open a query and immediately run it, point to it and then click the Open in a new tab and Execute Open in new tab and Execute icon.

To delete a stored query, point to a query and click the Delete icon Delete icon.

Public queries cannot be deleted.

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 using 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 are also 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.