The workspace details page lists all relevant information about the workspace and its child entities. It includes details on the datasets, ruleset templates, and the sync status of each dataset within the workspace.
You can d Page tour by clicking the Page tour option from the Help menu in the topbar. A page tour gives you a complete walkthrough of the workspace details page and helps you understand it better.
Let us take a look in detail.
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.
You can use the following options associated with your workspace from the workspace menu.
Rename : You can rename your workspace using the rename option.
Delete : Use this option to permanently delete the workspace from your organization.
: Set access permissions and share your workspace with other users in your organization. Learn more
Share with support
: Share your workspace with our support team using this option when you need help with addressing issues related to your workspace in Zoho DataPrep. Learn more
Mark as default : You can mark you workspace as default and DataPrep will automatically open this workspace for you when you launch.
Leave workspace : This option will be visible to the workspaces that are shared with you. You can choose to leave the workspace shared with you anytime. [Coming soon]
Overview : You can view the workspace overview for details such as the workspace name, created and last modified date and time, last modified user, associated tags, number of datasets and ruleset templates, shared users and if the workspace is locked from sharing. You can also rename, delete, and mark as default from the workspace overview.
To learn more about workspaces and other entities in DataPrep, click here
A dataset is a collection of discrete items of related data. Each workspace can contain multiple datasets. You can use the following options associated with your datasets available in the workspace details page.
The workspace details page contains information related to datasets such as the dataset name, total rows, last modified time, data quality and the associated tags. The data quality bar shows the amount of valid, invalid and missing data in your dataset.
: Click on the Add dataset
button to import data from various sources into DataPrep. Learn more
: You can associate tags to entities such as workspaces and datasets to identify, classify, or group them. Learn more
Reload data from source : Click on the reload icon of the respective dataset to reload data from its data source.
Schedule import and export
: You can schedule import and export of individual datasets right from the workspace details page. Learn more about scheduling import
: Set access permissions and share your dataset with other users in your organization. Learn more
Rename : You can rename your dataset using the rename option.
: Use this option to move your dataset to trash
Duplicate dataset : Use this option to quickly create a copy of dataset on your workspace.
: Prepared data is created every time data is processed for export. It is stored in Zoho DataPrep for audit purposes. You can export prepared data as files or choose to delete them if no longer necessary. Learn more
Share with support
: Share your dataset with our support team using this option when you need help with addressing issues related to your dataset in Zoho DataPrep. Learn more
Mark as ready to use
: You can mark datasets as ready to use after they are prepared and available for consumption. Learn more
Overview : Click on the info icon near the dataset name to go the dataset overview. You can view the dataset overview for details such as the dataset name, created and last modified date and time, last modified user, associated tags, number of columns, rules applied, data quality, prepared data, shared users, source and destinations and if the dataset is locked from sharing. You can also rename, delete, and mark your dataset ready to use from the dataset overview.
: You can filter and search on the workspace details page using filter attributes such as status, created by, data quality, tags, etc. Learn more
You can also quickly sort and search for your datasets using the respective icons located at the top of the list of dataset names. Use the checkboxes to the left of the dataset names to multi-select datasets to share, export or delete multiple datasets at one go.
To learn more about datasets and other entities in DataPrep, click here
Ruleset templates tab
Ruleset templates are rules applied in various datasets that are saved to be reused on other datasets. In the workspace details page, you can rename, share, or delete the ruleset templates available in your workspace.
You can also quickly sort and search for your ruleset templates using the respective icons located at the top of the list of ruleset template names. Use the checkboxes to the left of the names to multi-select the templates to share or delete multiple templates at one go.
You can share your ruleset with other users and groups when they are saved as templates. Learn more about saving and sharing ruleset templates from here
To learn more about ruleset templates and other entities in DataPrep, click here
When you schedule import and export for the datasets, you can see the status of each dataset under the Sync status section in the workspace details page.
Hover the respective icons to view the import, prepare, and export details and the status of the schedule. The details include the sync errors if any, next sync time, and the data source details. You can also quickly search for a particular dataset or workspace sync status using their names.
Click the View sync status for all workspaces
link at the top-right corner. The sync status of all the workspaces in the organization are listed in this page.
You can also click the Operations history icon near each sync status to view and track the changes made to the dataset, its previous states, the import and export schedules in a timeline.
The entities that are deleted can be located under the trash tab. You can choose to restore the entities or permanently delete them from the trash section.
You can also use the checkboxes to the left of the entity names to multi-select them and permanently delete or restore multiple entities at one go.