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.
Exporting Related Object Data
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.
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.
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.
Skyvia provides the following tutorials on data export: