You can execute SQL statements against a data source on the SQL view of a query. 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.
In order to execute an SQL statement perform the following steps:
|1.||On the Query page, click New SQL if there are no open queries. If there are open queries, click the button and then click SQL on the Query toolbar in order to create a new query.|
|2.||Click Select connection and select the connection to the data source you want to query data from in the list. If you haven't created the necessary connection yet, please first create one (learn how).|
|3.||Enter your query to the query editor box in the top right part of the page. In case you simply want to select data from an object, you may drag this object from the Connection Object List on the left to the query editor.|
|4.||Click Execute or press F9.|
You can also use parameters in the SQL code. See Using Parameters topic for more information.
If this was a statement that returns data, this the data are displayed in the Result area below the SQL editor after executing the statement. You can view the data in this area or switch to the Data view in order to hide SQL editor and have more place for viewing data on your screen. For this, click Data on the right side of the toolbar.
For cloud data sources only, after the execution of UPDATE and DELETE statements, the updated or deleted data is displayed in the grid. You can preview this updated data BEFORE the data in your cloud source are actually modified. This allows you to perform mass cloud data updates and deletes safely. After you have looked through the updated data, click Apply All, to apply them to the actual data in the cloud data source. Please note that for relational databases the changes are applied immediately, without preview.