1. What are "rows processed"?
A row can be defined in the context of a dataset. In simple terms, a dataset consists of rows (records) and columns (fields). Each row in a dataset represents a set of related data and has the same structure. For example, in a dataset containing employee data, each "row" would represent a single employee record.
In Zoho DataPrep, the total number of rows in your dataset that you import and the intermediate datasets created during the preparation process are counted towards "rows processed" for your plan. You can monitor the number of rows processed from the Manage Subscription page in DataPrep. The "rows processed" count is reset at the beginning of your billing cycle, every month.
2. How do you calculate "rows processed"? What rows are counted towards "rows processed"?
In Zoho DataPrep, the total number of rows that are processed are counted towards "rows processed" for your plan. When data is imported or exported manually or through schedule runs, the "rows processed" count will increase.
The rows that are processed includes, imported rows, row of any intermediate datasets created using Derive, Join, Append, Pivot, Unpivot, and other dataset creating transforms; wherein the number of rows processed to create/update the child datasets will also be counted towards "rows processed".
3. Triggering export multiple times on the same dataset without making any data changes or rule addition/edits will not generate a new output data. Therefore "rows processed" count will not increase in this case.
4. The "rows processed" count is reset at the beginning of your billing cycle, every month.
2. What is a "scheduled data source" in Zoho DataPrep?
A data source configured for import schedule is called a "scheduled data source". The number of scheduled data sources depends on your subscription plan. If a data import is scheduled from a distinct data source, it is counted as one scheduled data source irrespective of the number of schedules. Multiple datasets and disparate schedules can be set up for one data source type which will still be counted as one scheduled data source.
2 datasets from Zoho Analytics imported every 1hr
3 datasets from Zoho Analytics imported every day at 12noon
5 datasets from Amazon Redshift imported every 5 hrs
2 datasets from Amazon Redshift imported every 10 hrs
2 datasets from two different FTP servers imported every 3 hrs
1 dataset from Amazon RDS - MySQL imported every 1 hr
1 dataset from Amazon RDS - PostgreSQL imported every 1 hr
The total scheduled data sources count is now 5. (Zoho Analytics, Amazon Redshift, FTP, Amazon RDS MySQL, and Amazon RDS PostgreSQL)
If a data source is used to import a dataset and is not scheduled, then it will not be counted as a 'scheduled data source'.
3. What is a "scheduled data destination" in Zoho DataPrep?
A data destination configured for an export schedule is called a "scheduled data destination". The number of scheduled data destinations available depends on your subscription plan. If a data export is scheduled to a distinct export destination, it is counted as one scheduled data destination irrespective of the number of schedules. Multiple datasets and disparate schedules can be set up for one export destination and it will still be considered as one scheduled data destination.
2 datasets to Zoho Analytics exported every 1hr
3 datasets to Zoho Analytics exported every day at 12noon
5 datasets to Amazon Redshift exported every 5 hrs
2 datasets to a different Amazon Redshift account exported every 10 hrs
2 datasets to two different Google Drive accounts exported every 3 hrs
1 dataset to Amazon RDS - MySQL exported every 1 hr
1 dataset to Amazon RDS - PostgreSQL exported every 1 hr
The total scheduled data destinations count is now 5. (Zoho Analytics, Amazon Redshift, Google Drive, Amazon RDS MySQL, and Amazon RDS PostgreSQL)
If a data destination is used to export a dataset and is not scheduled, then it will not be counted as a 'scheduled data destination'.
4. Who is a "user" in Zoho DataPrep?
Anyone who is added to your account is considered a "user" in Zoho DataPrep. They can create datasets, prepare data, set up pipelines, collaborate, and share data with others, and more based on their roles and permissions. A user is identified by their unique email address using which their Zoho DataPrep account was created.
If you subscribe to a Zoho DataPrep plan for 3 users, you can add 2 other users. Now your Zoho DataPrep account has 3 users including yourself.
Users can be in different states and only the active users who are invited to be a part of your organization are counted towards license.
Users you've invited to your Zoho DataPrep organization.
Users who have access to your Zoho DataPrep organization.
Users who are marked as inactive. They can no longer access your Zoho DataPrep organization.
Users who are removed from your organization. They can no longer access your Zoho DataPrep organization.
5. Can I sign up for the Free Plan or the Trial and upgrade later?
You can sign up for the Free plan or for the 15-day Trial offered for the Standard plan (10M rows). You can evaluate the product and see if it meets your requirements. If it does, you can upgrade to a paid plan anytime. Your data will remain safe and will be retained fully on upgrade.
Even if you do not upgrade to a paid plan, you can continue to enjoy the Free Plan.
6. How about support? Is it charged separately?
We offer free technical support to all our customers. The support services offered vary based on the subscription plan purchased. Please refer to our Support plans
page for more details. You can avail technical support through any of the following means.
7. How can I purchase Premium support?
Please register for the premium support from the Support plans
8. Do you offer professional services for developing data preparation solutions?
Yes, we do. We also have a strong partner network who offer specific solutions. Please mail us at firstname.lastname@example.org
with your requirements, we will get back to you.
9. Is my data safe?
10. How long is the Trial period?
15 days. If you wish to extend your evaluation period, please contact
our support team.
11. What are the limitations during the Trial?
You will have the get all the features and capabilities of the Standard (10M rows) plan.
12. What happens after the Trial period ends?
You will be moved to the Free plan automatically if you haven't purchased a paid plan before the trial period ends.
13. What happens to "rows processed" limit after I downgrade to a lower plan?
If you have downgraded to a lower plan, the limitations of the downgraded plan will apply. This includes the already processed row count for the current month.
For example, Organization A is in the Standard 2M plan, on a billing cycle starting 1st of each month. Consider the Org A has downgraded to Free plan on the 20th of that month, with 1.5M rows processed already. After this downgrade the new limit is now 20K per month. Since the rows processed for the month (current billing cycle) already exceeded the limit, no more rows can be processed till the 1st of the next month.
14. What happens to "scheduled data sources" after I downgrade to a lower plan?
If there are more scheduled data sources than the allowed limit for the downgraded plan, Zoho DataPrep will retain the recently scheduled data sources to meet the limits of the downgraded plan and disable the scheduling for the older ones. If you had downgraded to the Free plan, all schedules will be disabled. If the account is not upgraded within 45 days after the downgrade, the disabled schedules will be permanently deleted.
15. What happens to "scheduled data destinations" after I downgrade to a lower plan?
If there are more scheduled data destinations than the allowed limit for the downgraded plan, Zoho DataPrep will retain the recently scheduled data destinations to meet the limits of the downgraded plan and disable the scheduling for the older ones. If you had downgraded to the Free plan, all schedules will be disabled. If the account is not upgraded within 45 days after the downgrade, the disabled schedules will be permanently deleted.
16. What happens to prepared data when I downgrade to a lower plan?
The prepared data older than a month in the case of downgrading to the Free plan, or two months in the case of downgrading to a lower Standard plan, will be permanently deleted immediately to free up space needed for you to run any data preparation flows further.
17. What happens to shared users and entities when I downgrade to the Free plan?
All users except you, the Account admin will be moved to the inactive state. You will still be able to view the user groups and shared entities across DataPrep for the next 45 days after which all the deactivated users and the share configuration will be permanently deleted if you do not upgrade to a paid plan within this duration.
18. What happens to those transforms that are not supported in the Free plan when I downgrade to the Free plan?
The unsupported transforms will not continue to work, and will be listed in error in your ruleset. You can either disable them or remove them from your ruleset to continue with your data preparation process within the limits of the Free plan.
List of unsupported transforms in the Free plan
- Formula column
- Window functions
- Fill empty cells using custom formulas.
- Sentiment analysis
- Keyword extraction
- Language detection
- De-duplicate column-wise
19. Can I upgrade, downgrade, or cancel my plan anytime?
Yes, Zoho DataPrep is a month-to-month, pay-as-you-go service. You can upgrade, downgrade, or cancel your subscription anytime.