Metadata is hugely important in the lifecycle and maintenance of good data. Workspaces allow you to add, update, maintain and export metadata for datasets.
As soon as a dataset has begun uploading, you can add metadata using the ‘Edit Metadata’ function, which can be accessed from the sidebar in the Dataset Overview or Dataset Preview.
Adding metadata manually
The following fields are available to specify or change metadata for the dataset:
- Title: the title of the dataset.
- Source: the source of the dataset. This is a text field which could be used to supply an URL or any other description of the source of the data.
- Description: a description of the dataset.
The following metadata can also be set for each column in the dataset:
- Label: a label for the dataset column.
- Description: a description of the column.
Adding metadata from a file
Instead of adding all of the metadata for your table manually, you can import the metadata from a Table Definition File (TDF) in your workspace. The file must be in XML format and should look similar to the Iris dataset example TDF, illustrated below. You can also download the TDF template here and edit it for your dataset.
Firstly, you should upload your TDF file using the normal upload process. Once your file is uploaded into your workspace, navigate to the Edit Metadata page of the table you're interested in and select the 'Import from file' button. Note, you need to confirm that you want to overwrite any existing metadata if it already exists.
Either search or navigate to your TDF XML file and select 'Confirm'. Your metadata will be added to the form where you can check and edit it.
Note that the metadata for the table columns is matched based on the header of the column rather than the order that the metadata file is in.
Copying metadata from another table
From the Edit Metadata page, you can also import metadata from other tables in your workspace.
Select the 'Copy from another dataset'. Again, if there is already metadata set then you'll need to confirm that you want to overwrite this. Select the table which you want to copy metadata from and click 'Confirm' and your metadata will show in the form.
From the Edit Metadata page, you can easily create an XML copy of your metadata by using the 'Export to file' button. Select the destination for your file and click 'Confirm'.