Query Overview

Skyvia Query is an online SQL client and query builder tool that allows querying and managing cloud and relational data with SQL statements. You can enter SQL statements via code editor or compose SELECT statements with visual query builder.

After you have executed the created query, Skyvia allows you to view queried data in the browser and export them as PDF or CSV files. Skyvia Query automatically loads returned data in portions of 20 rows. If a query returns more than 20 rows, you can load the next twenty rows by clicking the load more link or pressing F8. Skyvia also offers another way to export data — to export them using the Data Integration products. For more details, you can read the Export topic.

Each query has main query elements, among which are: three tabs with different query views (Builder view, SQL view and Data view), toolbar buttons (Save, Clone, Execute, etc.) for managing queries, sql editor, result field, connection list with connections, object list with objects, etc. We have tried to make the structure of query and its navigation as simple and confortable as possible.

Query SQL Editor

Connections

Skyvia Query allows getting data from various cloud applications, databases, cloud data warehouses, backups, etc.

To query data, first you need to create a connection to the corresponding data source (in case you have not created it yet) or select an existing one in the connection list on the left of the query page (screenshot).

Connection list

If you haven’t created the necessary connection yet, you can create it by clicking Add new at the bottom of the drop-down list and specify the connection parameters in the opened Connection window.

Connection window

To create different connections, you need to enter different sets of parameters. You can find more information on creating the corresponding connections in the Connections section of our documentation.

Viewing Connection Metadata

Skyvia Query allows viewing connection metadata. The Connection Object List to the left of the query editor displays the information on the metadata of available objects/tables from the target connection. After you select a connection, it will display all the available objects/tables by default. By clicking a certain table, you can see the list of its fields.

When the Connection Object List displays the list of table fields, it displays Relation icons to the right of foreign key fields. You can click this icon to navigate to the corresponding parent table. If you navigate to this table via a foreign key (FK), the name of the used foreign key column will be displayed. For more details about browsing tables by relations in the Connection Object List check How to Create Joins.

When Connection Object List displays the list of fields, it uses the special icons to show the field type: fields with string data, fields with numeric data, boolean fields, datetime fields, fields with binary data, virtual fields displayed by Skyvia, such as Records count pseudo-field.

Connection Object List

Query Editor

Query Editor contains different query views: Builder view, SQL view and Data view. Whenever necessary, you can easily switch between query views by clicking the corresponding buttons in the right part of the query toolbar.

Builder View allows composing a SELECT statement visually with Query Builder without typing a code. It displays the Query Builder and Results pane by default. When you design a query with Query Builder, a SELECT statement is generated automatically. You can access and edit this statement by switching to the SQL view.

SQL View allows typing and executing SQL statements directly. This view displays the SQL Editor and the Results pane. However, if you have entered or edited an SQL statement on the SQL view and then switch to the Builder view, these changes are not preserved. All the changes made on the SQL view are usually lost when switching to another view.

Data View provides more space for better viewing the query results. When you have created and executed a query using Builder or SQL view, you can switch to the Data view to take a better look on the returned data.

Supported Query Features

With Skyvia, you can apply different aggregation and expression functions to the fields/columns added to queries. The Details pane on the right displays only the functions applicable to the type of the selected column/field or object.

Supported Query Functions

Except aggregation and expression functions, you can also configure filters within your queries. After you have selected objects, apply filters to query data matching certain criteria or conditions. Depending on your needs, Skyvia Query offers different filters. For example, you can apply filters to query records for a certain month only or you can apply filters to get/exclude only rows with certain values. You can also add multiple filters, by uniting them in groups. Each group will consist of several filters and/or subgroups united with a logical operator (AND or OR).

Supported Query Filters

For more information, please visit the Configuring Queries with Query Builder topic.

Supported SQL Statements

Skyvia Query supports SQL SELECT, INSERT, UPDATE, and DELETE statements for cloud sources. For relational databases, Skyvia can execute all the statements, supported by the database, including DDL statements. For Backup Connections, Skyvia supports only SELECT statements. Skyvia Query supports all the Cloud Sources and Relational Databases, supported by other Skyvia tools.

Query Gallery provides you with a number of predefined public queries to different data sources. In the Query Gallery, you can find the most common use cases and query data quickly and easily.

You can also create your own queries and save them in the Query Gallery for future use. 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.