Data Discovery Guide

Back Next

Foreign Key Analysis Results

After you run a foreign key profile, click the profile name below the modeling editor to see the results of the analysis.

The results view lists the columns that meet the primary-foreign key inference criteria you defined. Click the

Options

button to edit the inference settings. Click a column name and select

Validate

to verify that an inferred key is a valid key for the data objects.

The following table describes the foreign key analysis properties:

Property	Description
Parent Primary Key	A primary key column in the parent data object that the profile uses to find foreign keys in a child object.
Child Foreign Key	A column that the profile infers as a foreign key to the parent primary key in the current row.
Inclusion %	The quantity of data values that match between the primary and foreign key, expresses as a percentage. You may see a variance in the Inclusion % value for an inferred column in the foreign key results and after you validate it. For an inferred column, Inclusion % is the number of unique, foreign key column values of a child object that match the unique, primary key column values of the parent object. After you validate an inferred column, it is the number of foreign key column values of a child object that match the primary key column values of the parent object.
Relationship Type	The type of relationship defined for the primary and foreign key columns before the profile runs. If you define a relationship before the profile runs, the profile returns data for the relationship even if the inclusion percentage figure does not meet the confidence threshold set for the profile.
Verified	Indicates that a user has validated the primary-foreign key relationship.
Last Run Time	Data and time the profile last ran.
Relationship Type (In Model)	Indicates that the profile verified the relationship between the columns.