Subscription Limits and Plans in More Details
Skyvia includes such four products as Data Integration, Backup, Query, and Connect. More information about pricing plans can be found on the Pricing page. By default, a new account is subscribed to a free plan for each product.
Skyvia products are used completely independently, and you need to pay only for the product that you use, if the free plan for this product is not enough for you. For example, if you use only data integration packages, you do not need to pay for Query, Backup, and Connect.
Number of Records
Data Integration pricing plans mostly depend on the number of records per month included into the subscription. This number of records includes all the records, which have been successfully processed by data integration packages, including:
- records, successfully created, deleted, or updated in the target by import and replication packages (even if the update operation updates the target record with the same values it already has).
- rows in the CSV files, produced by export packages
- both records, successfully created, deleted, or updated in source and target by synchronization packages.
- billed records in data flows and control flows — all success rows for all the Target components that use any connections other than cache or log.
Records, loaded by external packages called in control flows via the Execute Integration component, are displayed in the logs of the corresponding packages and are counted according to the their package kind rules. They do not appear in the billing records of the parent control flow.
Besides, for Free and Basic plans, records, processed by export packages or by import packages, importing CSV files, are counted separately, and have their own separate limit.
For example, if you have the Basic pricing plan, and have one (or more) package importing CSV files, and import package, loading data from a cloud app or from a database/data warehouse, the records processed by the first package will be counted to the 200k record limit. Records, processed by the second package are counted to the 25k record limit.
Records, processed by export packages are always counted to the 200k record limit in this case (to the 100k record limit in case of the Free plan), and records, processed by replication and synchronization packages are always counted to the 25k record limit (5k record limit in case of the Free plan).
Failed records are not counted. If you cancel package execution, the records, processed by the package are also not counted. Even though canceling a package can take time, and package may process more records after you cancel it, all the processed records won’t be counted if you cancel the package.
On your Account page you can see the number of used records. As for the numbers of records, processed by each package, you can find the corresponding numbers in the run history of your packages for each run.
If the number of processed records exceeds the number of records, the currently running packages will continue execution till their finish and can process more records than included in your subscription. However, after the number is exceeded, you won’t be able to start any more packages both automatically and manually, unless your pricing plan allows processing additional records over the price plan month limit.
Standard, Professional, and Enterprise plans allow processing more records than included in the subscription for additional costs. Note that this feature is not enabled by default in order to avoid unexpected additional payments. To load records over the subscription limits, you need to explicitly enable this feature on your Account page. For this, on the Subscriptions tab, turn toggle on for Data Integration in the line with Paid Records.
You can define schedules for your packages to run automatically. Lower pricing plans have certain limits on scheduling packages for automatic execution. The number of scheduled packages means the number of packages that can have enabled schedule simultaneously, and schedule frequency determines how often you may run each of your scheduled packages on the schedule.
If you define a schedule that runs a package more often than your subscription allows, you won’t be able to save this package till you modify or disable the schedule. The same occurs if you already reached the max number of scheduled packages and try to set the schedule for another package.
Note that on any pricing plan you can have as many packages as you need, and run them manually as often as you need, till you reach the record limit. The Professional and Enterprise pricing plans don’t have limits on the number of scheduled packages and allow scheduling them up to once per minute.
Backup pricing plans mostly differ in the storage space available for your backups. You can backup data from any number of connections/cloud app accounts, and only the total size of your backups matters. Additionally, the Free pricing plan does not allow scheduling backups for automatic execution. You can only run backup manually.
Note that every time a backup package is run, a full backup is performed. To determine a pricing plan that suits you, multiply the size of your data that you plan to backup by the number of snapshots you plan to keep.
Note also that by default, old snapshots are not deleted automatically. After you reach the limit of your subscription, backups are not performed anymore till you free space. In paid pricing plans you can configure deleting unneeded snapshots automatically or delete them manually. See Managing Storage Space and Deleting Old Snapshots for more information.
In the Free pricing plan, you cannot configure automatic cleanding of old snapshots, you can only delete them manually. Besides, snapshots are deleted automatically for free users and if they exceed their space limits for two weeks.
The free Query pricing plan limits the user to execute 5 queries per day. This includes all the successfully executed SELECT queries or other SQL statements. This also includes refreshing data, retrieved with Skyvia Query Google Sheets Add-on or Skyvia Query Excel Add-in, in Google Sheets or any queries executed via this add-on. Failed queries and browsing connection metadata in the objects list are not counted.
This pricing plan also limits the number of queries you can save for future use in the Query Gallery.
Besides, we reserve the right to introduce traffic limitations for the free plan, in case of using it to load huge data volumes.
Connect pricing plans differ in the volume of traffic that goes via your endpoints and availability of endpoint security features. Besides, the free pricing plan is designed to test Skyvia Connect. It allows enabling only one endpoint to a Cloud Source (not to database) and provides only 100 KB of traffic per month.
You can create any endpoints in Skyvia, but you cannot activate endpoints that use features not provided in your subscription. They will be inactive and won’t work. For example, for the Free pricing plan, you can activate only one endpoint and only to a cloud source. You cannot activate an endpoint to a database or cloud data warehouse. For the Free and Basic plans you cannot activate any endpoints, using authentications or access restrictions by IP.
If you exceed the traffic limits, currently running requests to your endpoint will finish successfully, but subsequent requests will return an error: “You have reached the limit of bytes transferred. The endpoint is blocked. You may upgrade your pricing plan to activate your endpoints”.