Contents x
    Understanding the Data Profile
    • 20 Mar 2024
    • 1 Minute to read
    • PDF
    Contents

    Understanding the Data Profile

    • Updated on 20 Mar 2024
    • 1 Minute to read
    • PDF
    Article Summary

    Overview

    Depending on the data type of the column that was profiled, the returned statistics may vary. At the top of the profile, you'll always see technical metadata. Technical metadata includes the column name, data type, number of rows, length (for strings), and more.

    The data profile is populated by running profile sets on a data source. For this reason, each data profile can be updated at different times depending on the content of a profile set. To view the recency of a profile statistic, hover over the gray circle next to the name. The color of the gray circle represents how recent the metadata is. The darker the circle, the more recent.

    The profile only shows the results of profile sets that were executed. If you’re missing profile information, go back into the Data Source and create a profile set containing the chosen data profile(s) on the appropriate objects.

    String Profiles

    image.png

    String profiles show the following information.

    Profile TypeData Profile
    Summary
    • Length
    • Is Nullable
    • Number of Rows
    • Number, Percent of Distinct Values
    • Number, Percent of Null Values
    • Number, Percent of Blank Values
    • Number, Percent of Numeric Values
    Analysis
    • Minimum Length
    • Average Length
    • Maximum Length
    Distribution
    • Length Distribution
    • Top 10 Values
    • Bottom 10 Values
    Length
    • Shortest Value
    • Longest Value

    Numeric Profiles

    image.png

    Numeric profiles show the following information.

    Profile TypeData Profile
    Summary
    • Is Nullable
    • Number of Rows
    • Number, Percent of Distinct Values
    • Number, Percent of Null Values
    Analysis
    • Minimum
    • Maximum
    • Average
    • Lower Quartile
    • Upper Quartile
    • Median
    Distribution
    • Numeric Distribution
    • Top 10 Values
    • Bottom 10 Values

    Date/Time Profiles

    Date/Time profiles show the following information.

    Profile TypeData Profile
    Summary
    • Is Nullable
    • Number of Rows
    • Number, Percent of Distinct Values
    • Number, Percent of Null Values
    Analysis
    • Minimum Date
    • Maximum Date
    Distribution
    • Top 10 Values
    • Year Distribution
    • Year Month Distribution
    Was this article helpful?
    What's Next