Contents x
    Configuring a Profile Set
    • 28 Jul 2023
    • 2 Minutes to read
    • PDF
    Contents

    Configuring a Profile Set

    • Updated on 28 Jul 2023
    • 2 Minutes to read
    • PDF
    Article Summary

    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?
    What's Next