- 28 Jul 2023
- 2 Minutes to read
Configuring a Profile Set
- Updated on 28 Jul 2023
- 2 Minutes to read
The Profile Set configuration screen is separated into three tabs:
- Profile Selection
- Object Selection
- Profile Set Configuration
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.
|Default Profile Sets||Validatar ships with three pre-configured profile sets:|
|Custom Profile Set||To customize a profile set, check any box to the left of the profile name to add it to the set.|
|Prerequisites||Prerequisites 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.
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.
|Schema Name||String Filters||Any string input|
|Table Name||String Filters||Any string input|
|Table Record Count||Numeric Filters||Any numeric input|
|Table Type||Equals, Not Equals||Table or View|
|Column Name||String Filters||Any string input|
|Column Data Type||String Filters||Any string input|
|Column Mapped Type||Equals, Not Equals||Validatar data types|
|Column Nullable||Equals, Not Equals||Yes or No|
|Column Identity||Equals, Not Equals||Yes or No|
|Column Primary Key||Equals, Not Equals||Yes or No|
|Column Max Length||Numeric Filters||Any numeric input|
|Add Filter||Add an object filter on the data profile set.|
|Preview Objects||Preview the objects that will be run on the data profile set.|
|Field||The type of object filter.|
|Operator||The comparison operator used for the object filter.|
|Criteria||The 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.
|Profile Connection||Select from the dropdown whether to use the primary connection or the specified profile connection.|
|Max Concurrent Queries||Determines 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 Query||Specifies 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.|