| Column Name | Column Data Type |
|---|
domain_name Required Input Column
The unique name of the domain. | VARCHAR |
job_id Required Input Column
The unique identifier of the Identity Resolution Job. | VARCHAR |
_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.
|
auto_merging
Configuration settings for how to perform the auto-merging of profiles. | STRUCT(
"enabled" BOOLEAN,
"consolidation" STRUCT(
"matching_attributes_list" VARCHAR[][]
),
"conflict_resolution" STRUCT(
"conflict_resolving_model" VARCHAR,
"source_name" VARCHAR
),
"min_allowed_confidence_score_for_merging" DOUBLE
) |
Show child fields- auto_merging.conflict_resolution
How the auto-merging process should resolve conflicts between different profiles. For example, if Profile A and Profile B have the same FirstName and LastName (and that is the matching criteria), which EmailAddress should be used? Show child fields- auto_merging.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. - auto_merging.conflict_resolution.source_name
The ObjectType name that is used to resolve profile merging conflicts when choosing SOURCE as the ConflictResolvingModel.
- auto_merging.consolidation
A list of matching attributes that represent matching criteria. If two profiles meet at least one of the requirements in the matching attributes list, they will be merged. Show child fields- auto_merging.consolidation.matching_attributes_list[][]
- auto_merging.enabled
The flag that enables the auto-merging of duplicate profiles. - auto_merging.min_allowed_confidence_score_for_merging
A number between 0 and 1 that represents the minimum confidence score required for profiles within a matching group to be merged during the auto-merge process. A higher score means higher similarity required to merge profiles.
|
exporting_location
The S3 location where the Identity Resolution Job writes result files. | STRUCT(
"s3_exporting" STRUCT(
"s3_bucket_name" VARCHAR,
"s3_key_name" VARCHAR
)
) |
Show child fields- exporting_location.s3_exporting
Information about the S3 location where Identity Resolution Jobs write result files. Show child fields- exporting_location.s3_exporting.s3_bucket_name
The name of the S3 bucket name where Identity Resolution Jobs write result files. - exporting_location.s3_exporting.s3_key_name
The S3 key name of the location where Identity Resolution Jobs write result files.
|
job_end_time
The timestamp of when the Identity Resolution Job was completed. | TIMESTAMP_S |
job_expiration_time
The timestamp of when the Identity Resolution Job will expire. | TIMESTAMP_S |
job_start_time
The timestamp of when the Identity Resolution Job was started or will be started. | TIMESTAMP_S |
job_stats
Statistics about the Identity Resolution Job. | STRUCT(
"number_of_profiles_reviewed" BIGINT,
"number_of_matches_found" BIGINT,
"number_of_merges_done" BIGINT
) |
Show child fields- job_stats.number_of_matches_found
The number of matches found. - job_stats.number_of_merges_done
The number of merges completed. - job_stats.number_of_profiles_reviewed
The number of profiles reviewed.
|
last_updated_at
The timestamp of when the Identity Resolution Job was most recently edited. | TIMESTAMP_S |
message
The error messages that are generated when the Identity Resolution Job runs. | VARCHAR |
status
The status of the Identity Resolution Job. -
PENDING: The Identity Resolution Job is scheduled but has not started yet. If you turn off the Identity Resolution feature in your domain, jobs in the PENDING state are deleted. -
PREPROCESSING: The Identity Resolution Job is loading your data. -
FIND_MATCHING: The Identity Resolution Job is using the machine learning model to identify profiles that belong to the same matching group. -
MERGING: The Identity Resolution Job is merging duplicate profiles. -
COMPLETED: The Identity Resolution Job completed successfully. -
PARTIAL_SUCCESS: There's a system error and not all of the data is merged. The Identity Resolution Job writes a message indicating the source of the problem. -
FAILED: The Identity Resolution Job did not merge any data. It writes a message indicating the source of the problem. | VARCHAR |