SQL Statements and Custom Queries Become Available in Import Packages

August 13, 2021

In May, Skyvia team improved and extended the functionality of export packages. This update was met by Skyvia users with genuine excitement and seemed to greatly simplify our clients' work.

As we constantly strive to improve our products and meet clients' growing business needs, we have decided to implement the same useful functionality in Import packages.

From now on, you can use the results of visually built queries and composed SQL Statements as a source in the tasks of your import packages and perform data transformations in a more complex way than before. We expect the new feature to bring an additional benefit for those who use Skyvia Data Integration.

Import Package Improvements

New Task Editor Mode

We have developed a new mode for import packages — Advanced mode. This mode is available when the new data integration runtime is selected. You need to select the Use new runtime checkbox in your import package before adding a task.

In the Advanced task editor mode, you can choose what action to use — either type and edit SQL statement of any complexity on your own (Execute Command) or create custom queries by means of our visual query builder (Execute Query). The new mode is equally convenient for SQL professionals and SQL beginners. The design is ergonomic and user-friendly.

Advanced Mode

Advanced Data Extraction

The new task editor mode provides powerful data extraction, allowing you to get prepared and preformatted data for import. For example, now you can perform aggregations, change capitalization, add various calculated columns, etc. You can import several tables joined in a more complex way than before.

SQL in Import Package

Please note that Skyvia supports only SQL SELECT statements in Import packages. When you import data using the Advanced task editor mode, the Returning feature and its settings are not available on the Mapping Definition tab.

Be the first to try custom queries and SQL as source actions in the import packages and give us your feedback! Have a technical question or need help? Our customer support team is always at hand.

Comments

Loading Comments