Skip to content
AWS for Query.Farm

aws.dms.describe_replication_task_assessment_results

Example SQL Queries

SELECT * FROM
aws.dms.describe_replication_task_assessment_results;

Description

Returns the task assessment results from the Amazon S3 bucket that DMS creates in your Amazon Web Services account. This action always returns the latest results.

For more information about DMS task assessments, see Creating a task assessment report in the Database Migration Service User Guide.

Table Definition

Column NameColumn Data Type
replication_task_arn Input Column

The Amazon Resource Name (ARN) string that uniquely identifies the task. When this input parameter is specified, the API returns only one result and ignore the values of the MaxRecords and Marker parameters. 

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
bucket_name

- The Amazon S3 bucket where the task assessment report is located. 

VARCHAR
replication_task_assessment_results

The task assessment report. 

STRUCT(
    "replication_task_identifier" VARCHAR,
    "replication_task_arn" VARCHAR,
    "replication_task_last_assessment_date" TIMESTAMP_S,
    "assessment_status" VARCHAR,
    "assessment_results_file" VARCHAR,
    "assessment_results" VARCHAR,
    "s3_object_url" VARCHAR
)[]
Show child fields
replication_task_assessment_results[]
Show child fields
replication_task_assessment_results[].assessment_results

The task assessment results in JSON format.

The response object only contains this field if you provide DescribeReplicationTaskAssessmentResultsMessage$ReplicationTaskArn in the request.

replication_task_assessment_results[].assessment_results_file

The file containing the results of the task assessment.

replication_task_assessment_results[].assessment_status

The status of the task assessment.

replication_task_assessment_results[].replication_task_arn

The Amazon Resource Name (ARN) of the replication task.

replication_task_assessment_results[].replication_task_identifier

The replication task identifier of the task on which the task assessment was run.

replication_task_assessment_results[].replication_task_last_assessment_date

The date the task assessment was completed.

replication_task_assessment_results[].s3_object_url

The URL of the S3 object containing the task assessment results.

The response object only contains this field if you provide DescribeReplicationTaskAssessmentResultsMessage$ReplicationTaskArn in the request.