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 open the Query page by clicking +NEW in the top menu and selecting Builder or SQL under QUERY.
Main Query Page Elements
You can create a new query by clicking +NEW in the top menu and selecting Builder or SQL under QUERY, or by using the Gallery button to open a query from the gallery. When one or more queries are opened, the Query page looks like the following:
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 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 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 is neither SQL editor nor Query Builder.
The Result pane displays the query results. When SQL statement returns an error, this error is also displayed in the results pane.
The rightmost buttons allow you to export query results in different formats. You can also hide and display the query results in the Result Pane by clicking button on the left.
Status bar displays query execution status, duration, and the number of displayed or affected records.
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.
You can hide and display Connection Object List using the button at the bottom.
Check Connection Object List for more detailed Connection Object List description.
Each query has the following views, which are different query representations: Builder view, SQL view, and Data view. Whenever necessary you can switch between query views by clicking the corresponding buttons in the right part of the query toolbar.
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.
The SQL view allows typing and executing SQL statements directly. This view displays SQL Editor and the Results pane.
Please note 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.
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.