Curation in the Analyst tool
Curation is the process of validating and managing discovered metadata of a data source so that the metadata is fit for use and reporting. When you curate metadata in the Analyst tool, you can approve, reject, and reset the inferred datatypes or data domains in profile results.
You can approve one datatype for a column. You can hide the rejected datatypes or data domains for a column. After you approve or reject an inferred datatype or data domain, you can reset the datatype or data domain to restore the inferred status.
Approving Datatypes
The profile results include the inferred datatypes for each column in the data source You can choose and approve a single datatype for each column in the Analyst tool.
1. In the Navigator, select the project or folder that contains the profile.
2. Click the profile to open it.
The profile opens in a tab.
3. In the Column Profiling view, select a column to view the value frequencies, patterns, datatypes, and statistics in the right panel.
4. In the right panel, click Datatypes.
The inferred datatypes for the column appear.
5. Select the column you want to approve and click Actions > Approve.
The status of the datatype changes to Approved.
6. To restore the inferred status of the datatype, select the datatype and click Actions > Reset.
Rejecting Datatypes
When you open the profile results, the Analyst tool displays approved datatypes by default. You can show or hide the rejected datatypes.
1. In the Navigator, select the project or folder that contains the profile.
2. Click the profile to open it.
The profile opens in a tab.
3. In the Column Profiling view, select a row.
4. To reject the inferred column datatypes, select the Datatypes view in the right panel. Select the inferred datatype that you want to reject, and click Actions > Reject.
The Analyst tool removes the rejected datatype from the list of datatypes.
5. To view the rejected datatypes, click Actions > Show Rejected.
6. To hide the rejected datatypes, click Actions > Hide Rejected.