You can create a custom profile or default profile. When you create a custom profile, you can configure the columns, rows to sample, and drilldown options. The default profile runs with all default options.
1. In the Discovery Home panel, click Data Object Profile or select New > Data Object profile from anywhere in the Analyst tool.
The New Profile wizard appears. The Column profiling option is selected by default.
2. Click Next.
3. In the Sources pane, select a data object.
4. Choose to create a default profile or custom profile.
- - To create a default profile, click Save or Save & Run.
- - To create a custom profile, click Next.
5. Enter a name and an optional description for the profile.
6. In the Folders pane, select the project or folder where you want to create the profile.
The Analyst tool displays the project that you selected and shared projects that contain folders where you can create the profile. The profiles in the folder appear in the right pane.
7. Click Next.
8. In the Columns pane, select the columns that you want to run a profile on. The columns include any rules you applied to the profile. The Analyst tool lists column properties, such as the name, datatype, precision, and scale for each column.
Optionally, select Name to select all columns.
9. In the Sampling Options pane, configure the sampling options.
10. In the Drilldown Options pane, configure the drilldown options.
Optionally, click Select Columns to select columns to drill down on. In the Drilldown columns dialog box, select the columns for drilldown and click OK.
11. Accept the default option in the Profile Results Option pane.
The first time you run the profile, the Analyst tool displays profile results for all columns selected for profiling.
12. Click Next.
13. Optionally, define a filter for the profile.
14. Click Next to verify the row drilldown settings including the preview columns for drilldown.
15. Click Save to create the profile, or click Save & Run to create the profile and then run the profile.