What are the limitations of Zoho DataPrep?

Technical limitations

Look into the below sections to understand the scope and limitations of Zoho DataPrep.

The sections below covers the various technical limitations in Zoho DataPrep. 

Import limits

Description
Limit
Maximum JSON file size supported during import
20 MB
Maximum XML file size supported during import
20 MB
Maximum local file size (other formats) supported during import
100 MB
Maximum local file size supported to import via Zoho Databridge
100 MB
Note 20 MB for JSON and XML files
Maximum file size supported to import from cloud storage services
1 GB
Maximum file size supported to import from FTP
1 GB
Maximum file size supported to import from FTP via Zoho Databridge
100 MB
Note: 30 MB for JSON and XML files
Maximum file size supported to import from URL
1 GB
Maximum number of files or tables supported during import 
10
Maximum records that can be imported from Zoho Analytics at a time
10 million
Maximum records that can be imported from Zoho CRM at a time
6 million
Maximum records that can be imported from Zoho Creator at a time
5 million


Export limits

Description
Limit
Maximum file size that can be exported to FTP
1 GB
Maximum file size that can be exported to cloud storage services
100 MB
Maximum records that can be exported to Zoho Analytics at a time
10 million
Maximum records that can be exported to Zoho CRM at a time
600,000
Maximum records that can be exported to Zoho Creator at a time 
1 million

Organization, workspace and other limits

Description
Limit
Maximum number of workspaces in an organization
100
Maximum number of users in an organization
100
Maximum number of connections in an organization
200
Maximum number of ruleset templates in a workspace
500
Maximum sample size supported
5 MB
Maximum cell size limit
2 MB
Maximum number of rules per stage
500
Maximum character limit for entity names (such as org name, workspace name, pipeline name, etc.)
100
Maximum number of clusters found in cluster and merge transform
300

Pipeline and related limits

Description
Limit
Maximum number of stages per pipeline
300
Maximum number of data sources per pipeline
100
Maximum number of destinations per pipeline
100
Maximum number of pipeline schedules allowed in an org
250
Maximum number of trigger-based jobs allowed for a pipeline in an hour(From Zoho Flow and Webhook)
4
Maximum number of pipeline templates in a workspace
500
Maximum number of columns allowed per stage
500
Maximum number of unstructured destinations per stage
3


SEE ALSO