Skip to main content

Dataset Details Page

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 the Alteryx Analytics Cloud, you can review source location and current usage for the ones to which you have access.

Status: For large relational datasets, you can track status of the import process. For more information, go to Descripción general del monitoreo de tareas.

DatasetDetailsPage-ImportedDataset-SS.png

Figure: Imported dataset details

Actions:

  • Preview: Review the first few rows of the dataset.

  • Make a copy: Create a copy of the imported dataset.

  • Edit name and description: Edit the name and description for the dataset.

  • Remove structure: Remove initial steps applied to structure data.

  • Refresh dataset:If available, this option refreshes the dataset's metadata with the latest source schema.

    Nota

    If you attempt to refresh the schema of a parameterized dataset based on a set of files, only the schema for the first file is checked for changes. If changes are detected, the other files are assumed to contain those changes as well. This can lead to changes being assumed or undetected in later files and potential data corruption.

Actions for dataset owners:

  • Transfer ownership: Transfer ownership of this asset to another users. Go to Transfer Asset Ownership.

  • Delete dataset:Delete the dataset.

    Nota

    This action only deletes the dataset reference that points to the file in the original data source. It does not delete the dataset in the original data source.

    Aviso

    Deleting a dataset can't be undone.

Reference Dataset

A reference dataset is a reference to the output of a set of transformations, which can be used elsewhere in the application. When the source dataset is modified, the reference dataset automatically receives the changes.

DatasetDetails-ReferenceDataset.png

Figure: Reference Dataset details

Actions:

  • 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.

    Aviso

    Deleting a dataset can't be undone.

Dataset with Parameters

If your dataset was created with parameters, you can review dataset and parameter information in the details.

DatasetDetails-DatasetWithParameters.png

Figure: Dataset with Parameters details

You can review the parameters and variables defined for the dataset.

Action:

  • Preview: Review the first few rows of the dataset.

  • Make a copy: Create a copy of the imported dataset.

  • Edit name and description: Edit the name and description for the dataset.

  • Edit parameters: Modify the parameters used to create the dataset. Go to Create Dataset with Parameters.

  • Remove structure: Remove the initial parsing structure. When the structure is removed:

    • The dataset is converted to an unstructured dataset. An unstructured 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.

  • Refresh dataset: If schema refresh is enabled, you can use this option to check for updates to the schema of the dataset source.

Actions for dataset owners:

  • Transfer ownership: Transfer ownership of this asset to another user. Go to Transfer Asset Ownership.

  • Delete dataset: Delete the dataset.

    Nota

    This action only deletes the dataset reference that points to the file in the original data source. It does not delete the dataset in the original data source.

    Aviso

    Deleting a dataset can't be undone.

Dataset with SQL

For datasets that were created with SQL statements, the following details are available.

Aviso

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.

Nota

If you modify the SQL statement for your imported dataset, any samples based on the old SQL statement are invalidated.

DatasetDetails-DatasetwithSQL.png

Figure: Dataset With SQL Details

Actions:

  • Preview: Review the first few rows of the dataset.

  • Edit custom SQL: Edit the custom SQL that has been used to define the dataset. For more information, go to Create Dataset with SQL.

  • Make a copy: Create a copy of the imported dataset.

  • Refresh dataset: Refresh the dataset.

Actions for dataset owners:

  • Transfer ownership: Transfer ownership of this asset to another user. Go to Transfer Asset Ownership.

  • Delete dataset: Delete the dataset.

    Nota

    This action only deletes the dataset reference that points to the file in the original data source. It does not delete the dataset in the original data source.

    Aviso

    Deleting a dataset can't be undone.