Query Page 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. Additionally Skyvia has the predefined Query Gallery, which contains a number of useful queries for common use cases.

Skyvia allows you to view queried data in the browser and export them to a CSV or PDF file. You can view data in a grid or visualize them as different kinds of charts. Charts also can be exported as images and PDF files.

You can open the Query page by clicking Query in the menu on the left side of the page.

ExpandedToggleIcon        Main Query Page Elements

When no query is open, the page looks like the following:

 

You can create a new query with the corresponding view opened with the New Builder, New SQL, or New Data button, or you can use the Gallery button to open a query from the gallery. When a one or more query is opened, the Query page looks like the following:

query-sql-editor-full

Tab Bar

Tab bar allows you to switch between open queries, create new ones and open queries from the Query Gallery. For more information about it read Query Page Reference.

Toolbar

Toolbar allows you to perform various actions with the query. The left part of the toolbar contains the connection list, where you can select a connection for the query, and buttons, which allow you to execute the query, save it to the Query Gallery, clear it, or clone it to a new query. The right part contains buttons that allow switching between query views. For more information about specific toolbar buttons read Query Page Reference.

SQL Editor

SQL Editor allows you to enter SQL statements and then execute them against the selected connection. You can also drag a table or a set of fields from the Connection Object List to SQL editor, and the corresponding SELECT statement will be generated automatically.

Please note that SQL editor is available only on the SQL view of a query. On the Builder view it is replaced with visual Query Builder, and on the Data view there are neither SQL editor nor Query Builder.

Result Pane

The Result pane displays the query results. It can display results in a grid or as charts. When SQL statement returns an error, this error is also displayed in the results pane.

You can switch between the grid and chart representation using the rightmost buttons of the Result pane header. The leftmost button allow you to export query results in different formats. For more information about working with returned data see Working with Returned Data and Results.

Status Bar

Status bar displays query execution status, duration, and the number of displayed or affected records. It also contains buttons that allow hiding and displaying Connection Object List and Results pane.

Connection Object List

Connection object list displays the information on the metadata of available objects from the target connection. It displays all the available objects of a connection or a list of fields from a selected object.

You can drag the connection objects or their fields to SQL editor, Query Builder, or Results pane to query their data. Dragging an object or a set of fields to Results pane immediately queries data from the dragged object or fields. Dragging an object or a set of fields to the SQL editor replaces its content with a simple query to this object or set of fields. As for Query Builder drag-n-drop support, you can read about it in the Query Builder topic.

See Connection Object List for more detailed Connection Object List description.

 

ExpandedToggleIcon        Query Views

Each query has the following views, which are different query representations: the Builder view, the SQL view, and the Data view. Whenever necessary you can switch between query views by clicking the corresponding buttons in the right part of the query toolbar.

Builder View

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

SQL View

The SQL view allows typing and executing SQL statements directly. This view displays SQL Editor and the Results pane.

note Note

Please notice that 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 lost in this case.

Data View

The 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.

 

You can also read Query Page Reference with the detailed reference on every user interface element.