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 that are processed is 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 is counted toward the "rows processed" limit for your plan.
Whenever data is imported or processed in your pipeline - whether you are building it by adding stages, adding rules within a stage, or running the pipeline - the "rows processed" count increases.
Rows involved in transformations such as Join, Append, Pivot, and Unpivot are included in this count. Any intermediate child stages generated from these transformations will also contribute to "rows processed", but only when those child stages have any rules applied.
However, if a child stage or derived stage does not contain any rules, it does not consume row processing. The only exception is the immediate stage(s) that come right after the data source - these stage(s) are always counted toward "rows processed", even if no rules are applied.
Note:
1. If you download the output data from job history, it will not increase the "rows processed" count.
2. The "rows processed" count is reset at the beginning of your billing cycle, every month.
3. How many data sources and destinations are counted for the license?
A data source or a destination is counted only once for licensing, even if used multiple times across different pipelines.
4. What is the batch size in Zoho DataPrep?
Batch size refers to the maximum number of rows you can process at a time in Zoho DataPrep during every import, data preparation, or export of data. The default batch size is 1 million. This means that you can process as many rows at a time as large as your batch size. However, you can always scale this limit by purchasing the Batch size Add-On from the Zoho Store.
Click here to learn more.
5. How do I increase my batch size?
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store.
c. Click the Upgrade Row/Add-Ons button.
d. Choose an option from the Batch Size Add-On dropdown.
d. You can review the price and add-on details in the After Addition section.
e. Click to Proceed and make payment. Once you complete your purchase successfully, you can refresh the Manage Subscription page in DataPrep to see your updated subscription details.
6. What scenarios will lead to a Batch size breach?
When you try to process rows more than your batch size limit, a Batch size breach occurs.
7. Who is a "user" in Zoho DataPrep?
Anyone who is added to your account is considered a "user" in Zoho DataPrep. They can import and prepare data in pipelines, collaborate, and share data with others, and more, based on the shared entity. 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 toward the license.
|
State
|
Description
|
Licensed?
|
|
Invited
|
Users you've invited to your Zoho DataPrep organization.
|
Yes
|
|
Active
|
Users who have access to your Zoho DataPrep organization.
|
Yes
|
|
Inactive
|
Users who are marked as inactive. They can no longer access your Zoho DataPrep organization.
|
No
|
|
Removed
|
Users who are removed from your organization. They can no longer access your Zoho DataPrep organization.
|
No
|
8. 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 the upgrade.
Even if you do not upgrade to a paid plan, you can continue to enjoy the Free Plan.
9. 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.
10. How can I purchase Premium support?
Please register for the premium support from the
Support plans page.
11. Do you offer professional services for developing data preparation solutions?
Yes, we do. We also have a strong partner network that offers specific solutions. Please email us at
support@zohodataprep.com with your requirements, and we will get back to you.
12. Is my data safe?
Zoho takes the security of your data and information very seriously. We encrypt your data while transmitting it to our servers and during storage. Zoho DataPrep strictly adheres to Zoho's data privacy policy and GDPR compliance. You can be assured that your data will remain confidential and secure. We have state-of-the-art security practices in place that help ensure the safety of your data. This includes physical security practices (like 7x24x365 security, video monitoring, biometric access, bullet-resistant walls), Network Security (encryption, intrusion detection/prevention), People Processes, and Redundancy/Business Continuity plans.
13. How long is the Trial period?
15 days. If you wish to extend your evaluation period, please
contact our support team.
14. What are the limitations during the Trial?
You will get all the features and capabilities of the Standard plan. But the rows processed count is limited to 2M.
15. 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.
16. What happens to "data sources" after I downgrade to a lower plan?
If there are more than the allowed data sources added in pipelines, you won't be able to add any more data sources to your pipelines or perform pipeline runs till the count is reduced to the current plan limits.
17. What happens to "data destinations" after I downgrade to a lower plan?
If there are more than the allowed data destinations added in pipelines, you won't be able to add any more destinations to your pipelines or perform pipeline runs till the count is reduced to the current plan limits.
18. 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.
19. What happens to the "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 that Org A has downgraded to the 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.
20. What happens to processed data when I downgrade to a lower plan?
The processed 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.
21. 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.
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
23. Can I delete my Zoho DataPrep organization if I am a paid customer?
Yes, but you will first have to go to Zoho Store and cancel your subscription if you have a purchased license for your organization in Zoho DataPrep. After successful cancellation, your organization will be moved to a free plan. You can then go ahead with deleting your organization in Zoho DataPrep.
24. Do I need to cancel my subscription to delete my Zoho DataPrep organization if I am in a free or trial plan?
No, if you are in a free or a trial plan, it means you do not have an active subscription for your Zoho DataPrep organization. Therefore, you can directly go ahead with deleting your organization in Zoho DataPrep.
25. How do I purchase Add-Ons in Zoho DataPrep?
You can purchase Add-Ons from the Zoho Store using the steps below:
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store
c. Click the Upgrade Row/Add-Ons button. Choose one or more from the following Add-Ons:
- Additional rows
- Users
- Scheduled data source
- Scheduled data destination
d. You can review the price and upgrade details in the After Addition section.
e. Click to Proceed and make payment. Once you complete your purchase successfully, you can return to the Manage Subscription page in DataPrep to see your updated subscription details.
2. How do I purchase more rows in Zoho DataPrep?
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store
c. Click the Upgrade Row/Add-Ons button.
d. Choose an option from the Additional Rows dropdown.
d. You can review the price and upgrade details in the After Addition section.
e. Click to Proceed and make payment. Once you complete your purchase successfully, you can return to the Manage Subscription page in DataPrep to see your updated subscription details.
3. How do I purchase more users in Zoho DataPrep?
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store
c. Click the Upgrade Row/Add-Ons button. Choose an option from the Users Add-On dropdown.
d. You can review the price and upgrade details in the After Addition section.
e. Click to Proceed and make payment. Once you complete your purchase successfully, you can return to the Manage Subscription page in DataPrep to see your updated subscription details.
4. How do I purchase more scheduled data sources in Zoho DataPrep?
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store
c. Click the Upgrade Row/Add-Ons button. Choose an option from the Scheduled data source Add-On dropdown.
d. You can review the price and upgrade details in the After Addition section.
e. Click to Proceed and make payment. Once you complete your purchase successfully, you can return to the Manage Subscription page in DataPrep to see your updated subscription details.
5. How do I purchase a scheduled data destination in Zoho DataPrep?
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store
c. Click the Upgrade Row/Add-Ons button. Choose an option from the Scheduled data destination Add-On dropdown.
d. You can review the price and upgrade details in the After Addition section.
e. Click to Proceed and make payment. Once you complete your purchase successfully, return to the Manage Subscription page in DataPrep to see your updated subscription details.
6. How do I downgrade my plan in Zoho DataPrep?
a. Click the Settings icon from the top-right corner to open the Settings tab.
b. Click the Manage Your Plan button, and you will be taken to Zoho Store
c. Click the Downgrade Row/Add-Ons button. Choose an option from the Scheduled data source Add-On dropdown.
d. Select one or more of the following options:
- No. of Rows
- Users Add-On
- Scheduled data sources
- Scheduled data destination
e. Click to Proceed. Once you downgrade your plan, return to the Manage Subscription page in DataPrep to see your updated subscription details.
9. How is storage defined in Zoho DataPrep? What adds to storage size in DataPrep?
In Zoho DataPrep, storage is the space occupied by the files you import,
processed data, and the new datasets created by transforms like join, append, etc. Each plan is allocated a certain storage limit. When you run out of space, you can
clear processed data to reclaim the storage.
10. What are the scheduled data sources in Zoho DataPrep?
A data source configured for an 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.
For example,
2 datasets from Zoho Analytics are imported every hour
3 datasets from Zoho Analytics are imported every day at 12noon
5 datasets from Amazon Redshift are imported every 5 hrs
2 datasets from Amazon Redshift are imported every 10 hrs
2 datasets from two different FTP servers are 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'.
11. 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.
For example,
2 datasets to Zoho Analytics were exported every 1 hour
3 datasets to Zoho Analytics are exported every day at 12noon
5 datasets to Amazon Redshift exported every 5 hrs
2 datasets to a different Amazon Redshift account are 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'.
12. What is a workspace in Zoho DataPrep?
Workspaces are entities that hold the various datasets imported into Zoho DataPrep. Organization admins carry out the responsibility of creating and managing workspaces in DataPrep.
13. What is a dataset in Zoho DataPrep?
A dataset is a collection of discrete items of related data. Each workspace can contain multiple datasets.
SEE ALSO