Curation in the Developer 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 Developer tool, you can approve, reject, and reset the inferred datatypes or data domains in profile results.
You can approve one datatype or data domain 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 in the Developer Tool
The profile results include the inferred datatypes, frequency, percentage of conformance, and the inference status 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 Object Explorer view, select and open a profile.
2. Verify that you are in the Results tab.
3. In the Column Profiling view, select a column to view the value frequencies, patterns, datatypes, and statistics in the right panel.
4. Under the Details panel, select Datatypes from the Show list.
The inferred datatypes for the column appear.
5. Right-click the column that you want to approve and click Approve.
The status of the datatype changes to Approved.
6. To restore the inferred status of the datatype, right-click the datatype and click Reset.
Rejecting Datatypes in the Developer Tool
When you view the profile results, the Developer tool displays inferred datatypes by default. You can reject inferred or approved datatypes. You can choose to show or hide the rejected datatypes.
1. In the Object Explorer view, select a profile.
2. Double-click the profile to open it.
The profile opens in a tab.
3. In the Column Profiling view, select a row.
4. To reject inferred column datatypes, select the Datatypes view in the right panel. Select the inferred datatype that you want to reject, right-click the row, and then select Reject.
The Developer tool greys out the rejected datatype in the list of datatypes.
5. To hide the rejected datatypes, right-click the row and select Hide Rejected.
6. To view the rejected datatypes, right-click one of the rows, and then select Show Rejected.