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 data types or data domains in profile results.
You can approve one data type or data domain for a column. You can hide the rejected data types or data domains for a column. After you approve or reject an inferred data type or data domain, you can reset the data type or data domain to restore the inferred status.
Approving Datatypes in the Developer Tool
The profile results include the inferred data types, frequency, percentage of conformance, and the inference status for each column in the data source. You can choose and approve a single data type for each column.
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 Data Types in the Developer Tool
When you view the profile results, the Developer tool displays inferred data types by default. You can reject inferred or approved data types. You can choose to show or hide the rejected data types.
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 data types, select the data types view in the right panel. Select the inferred data type that you want to reject, right-click the row, and then select Reject.
The Developer tool greys out the rejected data type in the list of data types.
5. To hide the rejected data types, right-click the row and select Hide Rejected.
6. To view the rejected data types, right-click one of the rows, and then select Show Rejected.