Skip to content
AWS for Query.Farm

aws.entityresolution.get_id_mapping_job

Example SQL Queries

SELECT * FROM
aws.entityresolution.get_id_mapping_job
WHERE
"job_id" = 'VALUE'
AND "workflow_name" = 'VALUE';

Description

Gets the status, metrics, and errors (if there are any) that are associated with a job.

Table Definition

Column NameColumn Data Type
job_id Required Input Column

The ID of the job.

VARCHAR
workflow_name Required Input Column

The name of the workflow.

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.

end_time

The time at which the job has finished.

TIMESTAMP_S
error_details

An object containing an error message, if there was an error.

STRUCT(
    "error_message" VARCHAR
)
Show child fields
error_details.error_message

The error message from the job, if there is one.

metrics

Metrics associated with the execution, specifically total records processed, unique IDs generated, and records the execution skipped.

STRUCT(
    "input_records" BIGINT,
    "records_not_processed" BIGINT,
    "total_mapped_records" BIGINT,
    "total_mapped_source_records" BIGINT,
    "total_mapped_target_records" BIGINT,
    "total_records_processed" BIGINT
)
Show child fields
metrics.input_records

The total number of records that were input for processing.

metrics.records_not_processed

The total number of records that did not get processed.

metrics.total_mapped_records

The total number of records that were mapped.

metrics.total_mapped_source_records

The total number of mapped source records.

metrics.total_mapped_target_records

The total number of distinct mapped target records.

metrics.total_records_processed

The total number of records that were processed.

output_source_config

A list of OutputSource objects.

STRUCT(
    "kms_arn" VARCHAR,
    "output_s3_path" VARCHAR,
    "role_arn" VARCHAR
)[]
Show child fields
output_source_config[]
Show child fields
output_source_config[].kms_arn

Customer KMS ARN for encryption at rest. If not provided, system will use an Entity Resolution managed KMS key.

output_source_config[].output_s3_path

The S3 path to which Entity Resolution will write the output table.

output_source_config[].role_arn

The Amazon Resource Name (ARN) of the IAM role. Entity Resolution assumes this role to access Amazon Web Services resources on your behalf as part of workflow execution.

start_time

The time at which the job was started.

TIMESTAMP_S
status

The current status of the job.

VARCHAR