Contents:
Use the Dataset Details page to review a dataset's usage and to perform management tasks on it.
Imported Dataset
For datasets that have been imported into Designer Cloud Enterprise Edition, you can review source location and current usage within flows to which you have access.
If the dataset is used in a flow, click the flow name to review its usage in the flow. See Flow View Page.
Figure: Imported dataset details
Actions:
- Wrangle in New Flow: Create a new flow for your dataset and begin wrangling.
- Preview: Review the first few rows of the dataset.
- Add to Flow: Add imported dataset to a new or existing flow.
- Edit name and description: Edit the name and description for the dataset.
Delete Dataset: Delete the dataset.
Deleting a dataset cannot be undone.
If the dataset was imported with a customized SQL statement, click Custom SQL. Modify the SQL statement(s) as needed.
Through the custom SQL interface, it is possible to enter SQL statements that can delete data, change table schemas, or otherwise corrupt the targeted database. Please use this feature with caution.
NOTE: If you modify the SQL statement for your imported dataset, any samples based on the old SQL statement are invalidated.
For more information, see Create Dataset with SQL.
For more information on the sources from which a dataset was created, see Flow View Page .
Reference Dataset
Figure: Reference Dataset details
Actions:
- Add to Flow: Add the reference dataset to a new or existing flow.
- Preview: Review a preview of the first few rows in the dataset.
- Edit name and description: Edit the name and description for the dataset.
Delete Reference Dataset: Delete the reference dataset. The object on which the reference dataset is based is untouched.
Deleting a dataset cannot be undone.
Dataset with Parameters
If your dataset was created with parameters, you can review dataset and parameter information in the details.
- For more information on creating these datasets, see Create Dataset with Parameters.
- For more information, see Overview of Parameterization.
Figure: Dataset with Parameters details
Action:
- Wrangle in new Flow: Create a new flow for your dataset and begin wrangling.
- Preview: Review the first few rows of the dataset.
- Add to Flow: Add imported dataset to a new or existing flow.
- Edit name and description: Edit the name and description for the dataset.
- Edit parameters: Modify the parameters used to create the dataset. See Create Dataset with Parameters.
- Remove structure: Remove the initial parsing structure. When the structure is removed:
- The dataset is converted to a raw dataset. A raw dataset is the source data converted into a flat file format.
- All steps to shape the dataset are removed. You must break up columns in manual steps in any recipe created from the object. See Flow View Page.
Delete Dataset: Delete the dataset.
Deleting a dataset cannot be undone.
This page has no comments.