Export Overview

Skyvia export operation is used to export cloud application or relational database data to CSV files, either locally downloaded or placed to cloud file storage services.

Multiple Export Tasks

Skyvia allows performing several export tasks in one package and, thus, export several database tables or cloud objects together in a single export operation.

Skyvia allows you to select fields to export from the main source object and its related objects. For example when you export prices from the Salesforce PriceBookEntry object, you can easily include product Name from the Product2 object and pricebook name from the Pricebook2 object.

Powerful Filtering

Skyvia provides powerful filter settings, which allow filtering exported data by the fields of the exported object and its related objects regardless of whether the filter fields are added to exported data or not. You can add any number of filter conditions, unite them in groups with different logical operators and create filters as complex as you may ever need.

SQL and Query Builder Support

Skyvia also allows querying data with SQL statements in the export packages. You can enter SQL statements yourself and edit via code editor if needed or compose SELECT statements with our convenient query builder.

Skyvia supports SQL and Query Builder functionality only for the export packages, which use the new data integration runtime, and only when the advanced task editor mode is selected. Read more about it here.

Compression Support

Skyvia allows compressing the result files using either zip or gzip compression.

When exporting date/time data, Skyvia converts it to UTC.

When you export data to a CSV file to your PC, the files are available for download for 7 days.

Export Tutorials

Skyvia provides the following tutorials on data export: