Configuring a Profile Set
  • 09 May 2022
  • 2 Minutes to read
  • PDF

Configuring a Profile Set

  • PDF

Overview

The Profile Set configuration screen is separated into three tabs:

  1. Profile Selection
  2. Object Selection
  3. Profile Set Configuration

Profile Selection

The profile selection tab is where you select the data profile you want to include in a profile set out of a list of data profiles available for that respective data source to use. The list of available data profiles depends on which profiles are enabled for the respective database engine. See more in Global Settings – Database Engines.

Displayed Information

Data Source - Profile Sets.png



Default Profile SetsValidatar ships with three pre-configured profile sets:
  • Table Profile: Selects all profiles that are run on a table level. E.g., table record count
  • Full Column Profile: Selects all profiles that are run on a column level. E.g., distinct count or null count
  • Basic Column Profile: Selects a smaller number of column-level profiles to run.
Custom Profile SetTo customize a profile set, check any box to the left of the profile name to add it to the set.
PrerequisitesPrerequisites appear when you have added a profile to the profile set and that profile is dependent on another profile to be run first.
For example, if you want to run a Distinct Count profile you must include the Record Count profile in the profile set. To know what the distinct count is, you must have the total record count for that table.
Any missing prerequisites are highlighted in orange and can be added by simply selecting the add plus sign screenshot button.

Object Selection

Displayed Information

Data Source - Profile Sets - Obj 1.png

Note

Add filters on your profile sets to limit the number of objects that will be profiled. View the Profile Set Statistics box as you add filters so you can see how extensive running the profile set will be on your database.

Filter Options

FieldOperatorCriteria
Schema NameString FiltersAny string input
Table NameString FiltersAny string input
Table Record CountNumeric FiltersAny numeric input
Table TypeEquals, Not EqualsTable or View
Column NameString FiltersAny string input
Column Data TypeString FiltersAny string input
Column Mapped TypeEquals, Not EqualsValidatar data types
Column NullableEquals, Not EqualsYes or No
Column IdentityEquals, Not EqualsYes or No
Column Primary KeyEquals, Not EqualsYes or No
Column Max LengthNumeric FiltersAny numeric input

Action Buttons



Add FilterAdd an object filter on the data profile set.
Preview ObjectsPreview the objects that will be run on the data profile set.

Table Headers



FieldThe type of object filter.
OperatorThe comparison operator used for the object filter.
CriteriaThe criteria must be met by an object to be included in the filter.

Profile Set Configuration

The profile set configuration tab contains advanced configuration settings that affect how a profile set is executed.

Displayed Information

Data Source - Profile Set Config.png



Profile ConnectionSelect from the dropdown whether to use the primary connection or the specified profile connection.
Max Concurrent QueriesDetermines the maximum number of SQL queries that will be run concurrently when the profile set is executed. The value can range from 0 to 20.
Max Profiles Per QuerySpecifies the number of separate profiles that can be grouped together into one query for a given object. A higher value reduces the total number of queries that are generated when this profile set is executed.
Purge Results After Days
Choose to purge profile results after a certain number of days.

Was this article helpful?