Skip to content
AWS for Query.Farm

aws.customer_profiles.get_auto_merging_preview

Example SQL Queries

SELECT * FROM
aws.customer_profiles.get_auto_merging_preview
WHERE
"domain_name" = 'VALUE'
AND "consolidation" = 'VALUE'
AND "conflict_resolution" = 'VALUE';

Description

Tests the auto-merging settings of your Identity Resolution Job without merging your data. It randomly selects a sample of matching groups from the existing matching results, and applies the automerging settings that you provided. You can then view the number of profiles in the sample, the number of matches, and the number of profiles identified to be merged. This enables you to evaluate the accuracy of the attributes in your matching list.

You can't view which profiles are matched and would be merged.

We strongly recommend you use this API to do a dry run of the automerging process before running the Identity Resolution Job. Include at least two matching attributes. If your matching list includes too few attributes (such as only FirstName or only LastName), there may be a large number of matches. This increases the chances of erroneous merges.

Table Definition

Column NameColumn Data Type
conflict_resolution Required Input Column

How the auto-merging process should resolve conflicts between different profiles.

STRUCT(
    "conflict_resolving_model" VARCHAR,
    "source_name" VARCHAR
)
Show child fields
conflict_resolution.conflict_resolving_model

How the auto-merging process should resolve conflicts between different profiles.

  • RECENCY: Uses the data that was most recently updated.

  • SOURCE: Uses the data from a specific source. For example, if a company has been aquired or two departments have merged, data from the specified source is used. If two duplicate profiles are from the same source, then RECENCY is used again.

conflict_resolution.source_name

The ObjectType name that is used to resolve profile merging conflicts when choosing SOURCE as the ConflictResolvingModel.

consolidation Required Input Column

A list of matching attributes that represent matching criteria.

STRUCT(
    "matching_attributes_list" VARCHAR[][]
)
Show child fields
consolidation.matching_attributes_list[][]
domain_name Required Input Column

The unique name of the domain.

VARCHAR
min_allowed_confidence_score_for_merging Input Column

Minimum confidence score required for profiles within a matching group to be merged during the auto-merge process.

DOUBLE
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

number_of_matches_in_sample

The number of match groups in the domain that have been reviewed in this preview dry run.

BIGINT
number_of_profiles_in_sample

The number of profiles found in this preview dry run.

BIGINT
number_of_profiles_will_be_merged

The number of profiles that would be merged if this wasn't a preview dry run.

BIGINT