Profile Options

You use the Discovery workspace to configure the profile options. You can choose to create a profile with the default options for columns, sampling, and drill-down options. Use the drill-down option to choose between live data and staged data.

Sampling Options

Sampling options determine the number of rows that the Analyst tool chooses to run a profile on. You can configure sampling options when you define a profile or when you run a profile.

Option	Description
All rows	Chooses all rows in the data object.
Sample first <number> rows	The number of rows that you want to run the profile against. The Analyst tool chooses the rows from the first rows in the source.
Random sample <number> rows	The number of rows for a random sample to run the profile against. Random sampling forces the Analyst tool to perform drilldown on staged data. Note that this option can impact the drill-down performance.
Random sample	Random sample size based on the number of rows in the data object. Random sampling forces the Analyst tool to perform drilldown on staged data. Note that this option can impact the drill-down performance.
Exclude approved data types and data domains from the data type and data domain inference in the subsequent profile runs	Excludes the approved data type or data domain from data type and data domain inference from the next profile run.

Drilldown Options

Options	Description
Live	Drills down on live data to read current data in the data source.
Staged	Drills down on staged data to read profile data that is staged in the profiling warehouse.
Select Columns	Identifies columns for drilldown that you did not select for profiling.