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.
In the
Object Explorer
view, select and open a profile.
Verify that you are in the
Results
tab.
In the
Column Profiling
view, select a column to view the value frequencies, patterns, data types, and statistics in the right panel.
Under the
Details
panel, select
Data types
from the
Show
list.
The inferred data types for the column appear.
Right-click the column that you want to approve and click
Approve
.
The status of the data type changes to
Approved
.
To restore the inferred status of the data type, right-click the data type and click