Skip to content
AWS for Query.Farm

aws.apptest.get_test_run_step

Example SQL Queries

SELECT * FROM
aws.apptest.get_test_run_step
WHERE
"test_run_id" = 'VALUE'
AND "step_name" = 'VALUE';

Description

Gets a test run step.

Table Definition

Column NameColumn Data Type
step_name Required Input Column

The step name of the test run step.

VARCHAR
test_run_id Required Input Column

The test run ID of the test run step.

VARCHAR
test_case_id Input Column

The test case ID of the test run step.

VARCHAR
test_suite_id Input Column

The test suite ID of the test run step.

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.

after_step

The after steps of the test run step.

BOOLEAN
before_step

The before steps of the test run step.

BOOLEAN
run_end_time

The run end time of the test run step.

TIMESTAMP_S
run_start_time

The run start time of the test run step.

TIMESTAMP_S
status

The status of the test run step.

VARCHAR
status_reason

The status reason of the test run step.

VARCHAR
step_run_summary

The step run summary of the test run step.

STRUCT(
    "mainframe_action" STRUCT(
        "batch" STRUCT(
            "step_input" STRUCT(
                "resource" STRUCT(
                    "m2_managed_application" STRUCT(
                        "application_id" VARCHAR,
                        "runtime" VARCHAR,
                        "listener_port" BIGINT
                    ),
                    "m2_non_managed_application" STRUCT(
                        "vpc_endpoint_service_name" VARCHAR,
                        "listener_port" BIGINT,
                        "runtime" VARCHAR,
                        "web_app_name" VARCHAR
                    )
                ),
                "batch_job_name" VARCHAR,
                "batch_job_parameters" MAP(VARCHAR, VARCHAR),
                "export_data_set_names" VARCHAR[],
                "properties" STRUCT(
                    "dms_task_arn" VARCHAR
                )
            ),
            "step_output" STRUCT(
                "data_set_export_location" VARCHAR,
                "dms_output_location" VARCHAR,
                "data_set_details" STRUCT(
                    "type" VARCHAR,
                    "name" VARCHAR,
                    "ccsid" VARCHAR,
                    "format" VARCHAR,
                    "length" BIGINT
                )[]
            )
        ),
        "tn3270" STRUCT(
            "step_input" STRUCT(
                "resource" STRUCT(
                    "m2_managed_application" STRUCT(
                        "application_id" VARCHAR,
                        "runtime" VARCHAR,
                        "listener_port" BIGINT
                    ),
                    "m2_non_managed_application" STRUCT(
                        "vpc_endpoint_service_name" VARCHAR,
                        "listener_port" BIGINT,
                        "runtime" VARCHAR,
                        "web_app_name" VARCHAR
                    )
                ),
                "script" STRUCT(
                    "script_location" VARCHAR,
                    "type" VARCHAR
                ),
                "export_data_set_names" VARCHAR[],
                "properties" STRUCT(
                    "dms_task_arn" VARCHAR
                )
            ),
            "step_output" STRUCT(
                "data_set_export_location" VARCHAR,
                "dms_output_location" VARCHAR,
                "data_set_details" STRUCT(
                    "type" VARCHAR,
                    "name" VARCHAR,
                    "ccsid" VARCHAR,
                    "format" VARCHAR,
                    "length" BIGINT
                )[],
                "script_output_location" VARCHAR
            )
        )
    ),
    "compare_action" STRUCT(
        "type" STRUCT(
            "file_type" STRUCT(
                "datasets" STRUCT(
                    "step_input" STRUCT(
                        "source_location" VARCHAR,
                        "target_location" VARCHAR,
                        "source_data_sets" STRUCT(
                            "type" VARCHAR,
                            "name" VARCHAR,
                            "ccsid" VARCHAR,
                            "format" VARCHAR,
                            "length" BIGINT
                        )[],
                        "target_data_sets" STRUCT(
                            "type" VARCHAR,
                            "name" VARCHAR,
                            "ccsid" VARCHAR,
                            "format" VARCHAR,
                            "length" BIGINT
                        )[]
                    ),
                    "step_output" STRUCT(
                        "comparison_output_location" VARCHAR,
                        "comparison_status" VARCHAR
                    )
                ),
                "database_cdc" STRUCT(
                    "step_input" STRUCT(
                        "source_location" VARCHAR,
                        "target_location" VARCHAR,
                        "output_location" VARCHAR,
                        "source_metadata" STRUCT(
                            "type" VARCHAR,
                            "capture_tool" VARCHAR
                        ),
                        "target_metadata" STRUCT(
                            "type" VARCHAR,
                            "capture_tool" VARCHAR
                        )
                    ),
                    "step_output" STRUCT(
                        "comparison_output_location" VARCHAR,
                        "comparison_status" VARCHAR
                    )
                )
            )
        )
    ),
    "resource_action" STRUCT(
        "cloud_formation" STRUCT(
            "create_cloudformation" STRUCT(
                "step_input" STRUCT(
                    "template_location" VARCHAR,
                    "parameters" MAP(VARCHAR, VARCHAR)
                ),
                "step_output" STRUCT(
                    "stack_id" VARCHAR,
                    "exports" MAP(VARCHAR, VARCHAR)
                )
            ),
            "delete_cloudformation" STRUCT(
                "step_input" STRUCT(
                    "stack_id" VARCHAR
                ),
                "step_output" BOOLEAN
            )
        ),
        "m2_managed_application" STRUCT(
            "step_input" STRUCT(
                "application_id" VARCHAR,
                "runtime" VARCHAR,
                "vpc_endpoint_service_name" VARCHAR,
                "listener_port" BIGINT,
                "action_type" VARCHAR,
                "properties" STRUCT(
                    "force_stop" BOOLEAN,
                    "import_data_set_location" VARCHAR
                )
            ),
            "step_output" STRUCT(
                "import_data_set_summary" MAP(VARCHAR, VARCHAR)
            )
        ),
        "m2_non_managed_application" STRUCT(
            "step_input" STRUCT(
                "vpc_endpoint_service_name" VARCHAR,
                "listener_port" BIGINT,
                "runtime" VARCHAR,
                "web_app_name" VARCHAR,
                "action_type" VARCHAR
            ),
            "step_output" BOOLEAN
        )
    )
)
Show child fields
step_run_summary.compare_action

The compare action of the step run summary.

Show child fields
step_run_summary.compare_action.type

The type of the compare action summary.

Show child fields
step_run_summary.compare_action.type.file_type

The file type of the file.

Show child fields
step_run_summary.compare_action.type.file_type.database_cdc

The database CDC of the compare file type.

Show child fields
step_run_summary.compare_action.type.file_type.database_cdc.step_input

The step input of the compare database CDC summary.

Show child fields
step_run_summary.compare_action.type.file_type.database_cdc.step_input.output_location

The output location of the compare database CDC step input.

step_run_summary.compare_action.type.file_type.database_cdc.step_input.source_location

The source location of the compare database CDC step input.

step_run_summary.compare_action.type.file_type.database_cdc.step_input.source_metadata

The source metadata of the compare database CDC step input.

Show child fields
step_run_summary.compare_action.type.file_type.database_cdc.step_input.source_metadata.capture_tool

The capture tool of the source database metadata.

step_run_summary.compare_action.type.file_type.database_cdc.step_input.source_metadata.type

The type of the source database metadata.

step_run_summary.compare_action.type.file_type.database_cdc.step_input.target_location

The target location of the compare database CDC step input.

step_run_summary.compare_action.type.file_type.database_cdc.step_input.target_metadata

The target metadata location of the compare database CDC step input.

Show child fields
step_run_summary.compare_action.type.file_type.database_cdc.step_input.target_metadata.capture_tool

The capture tool of the target database metadata.

step_run_summary.compare_action.type.file_type.database_cdc.step_input.target_metadata.type

The type of the target database metadata.

step_run_summary.compare_action.type.file_type.database_cdc.step_output

The step output of the compare database CDC summary.

Show child fields
step_run_summary.compare_action.type.file_type.database_cdc.step_output.comparison_output_location

The comparison output of the compare database CDC step output.

step_run_summary.compare_action.type.file_type.database_cdc.step_output.comparison_status

The comparison status of the compare database CDC step output.

step_run_summary.compare_action.type.file_type.datasets

The data sets in the compare file type.

Show child fields
step_run_summary.compare_action.type.file_type.datasets.step_input

The step input of the compare data sets summary.

Show child fields
step_run_summary.compare_action.type.file_type.datasets.step_input.source_data_sets[]
Show child fields
step_run_summary.compare_action.type.file_type.datasets.step_input.source_data_sets[].ccsid

The CCSID of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.source_data_sets[].format

The format of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.source_data_sets[].length

The length of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.source_data_sets[].name

The name of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.source_data_sets[].type

The type of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.source_location

The source location of the compare data sets step input location.

step_run_summary.compare_action.type.file_type.datasets.step_input.target_data_sets[]
Show child fields
step_run_summary.compare_action.type.file_type.datasets.step_input.target_data_sets[].ccsid

The CCSID of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.target_data_sets[].format

The format of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.target_data_sets[].length

The length of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.target_data_sets[].name

The name of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.target_data_sets[].type

The type of the data set.

step_run_summary.compare_action.type.file_type.datasets.step_input.target_location

The target location of the compare data sets step input location.

step_run_summary.compare_action.type.file_type.datasets.step_output

The step output of the compare data sets summary.

Show child fields
step_run_summary.compare_action.type.file_type.datasets.step_output.comparison_output_location

The comparison output location of the compare data sets step output.

step_run_summary.compare_action.type.file_type.datasets.step_output.comparison_status

The comparison status of the compare data sets step output.

step_run_summary.mainframe_action

The mainframe action of the step run summary.

Show child fields
step_run_summary.mainframe_action.batch

The batch of the mainframe action summary.

Show child fields
step_run_summary.mainframe_action.batch.step_input

The step input of the batch summary.

Show child fields
step_run_summary.mainframe_action.batch.step_input.batch_job_name

The batch job name of the batch step input.

step_run_summary.mainframe_action.batch.step_input.batch_job_parameters

The batch job parameters of the batch step input.

step_run_summary.mainframe_action.batch.step_input.export_data_set_names[]
step_run_summary.mainframe_action.batch.step_input.properties

The properties of the batch step input.

Show child fields
step_run_summary.mainframe_action.batch.step_input.properties.dms_task_arn

The DMS task ARN of the mainframe action properties.

step_run_summary.mainframe_action.batch.step_input.resource

The resource of the batch step input.

Show child fields
step_run_summary.mainframe_action.batch.step_input.resource.m2_managed_application

The AWS Mainframe Modernization managed application in the mainframe resource summary.

Show child fields
step_run_summary.mainframe_action.batch.step_input.resource.m2_managed_application.application_id

The application ID of the AWS Mainframe Modernization managed application summary.

step_run_summary.mainframe_action.batch.step_input.resource.m2_managed_application.listener_port

The listener port of the AWS Mainframe Modernization managed application summary.

step_run_summary.mainframe_action.batch.step_input.resource.m2_managed_application.runtime

The runtime of the AWS Mainframe Modernization managed application summary.

step_run_summary.mainframe_action.batch.step_input.resource.m2_non_managed_application

The AWS Mainframe Modernization non-managed application in the mainframe resource summary.

Show child fields
step_run_summary.mainframe_action.batch.step_input.resource.m2_non_managed_application.listener_port

The listener port of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.batch.step_input.resource.m2_non_managed_application.runtime

The runtime of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.batch.step_input.resource.m2_non_managed_application.vpc_endpoint_service_name

The VPC endpoint service name of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.batch.step_input.resource.m2_non_managed_application.web_app_name

The web application name of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.batch.step_output

The step output of the batch summary.

Show child fields
step_run_summary.mainframe_action.batch.step_output.data_set_details[]
Show child fields
step_run_summary.mainframe_action.batch.step_output.data_set_details[].ccsid

The CCSID of the data set.

step_run_summary.mainframe_action.batch.step_output.data_set_details[].format

The format of the data set.

step_run_summary.mainframe_action.batch.step_output.data_set_details[].length

The length of the data set.

step_run_summary.mainframe_action.batch.step_output.data_set_details[].name

The name of the data set.

step_run_summary.mainframe_action.batch.step_output.data_set_details[].type

The type of the data set.

step_run_summary.mainframe_action.batch.step_output.data_set_export_location

The data set export location of the batch step output.

step_run_summary.mainframe_action.batch.step_output.dms_output_location

The Database Migration Service (DMS) output location of the batch step output.

step_run_summary.mainframe_action.tn3270

The tn3270 port of the mainframe action summary.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input

The step input of the TN3270 summary.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input.export_data_set_names[]
step_run_summary.mainframe_action.tn3270.step_input.properties

The properties of the TN3270 step input.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input.properties.dms_task_arn

The DMS task ARN of the mainframe action properties.

step_run_summary.mainframe_action.tn3270.step_input.resource

The resource of the TN3270 step input.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input.resource.m2_managed_application

The AWS Mainframe Modernization managed application in the mainframe resource summary.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input.resource.m2_managed_application.application_id

The application ID of the AWS Mainframe Modernization managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.resource.m2_managed_application.listener_port

The listener port of the AWS Mainframe Modernization managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.resource.m2_managed_application.runtime

The runtime of the AWS Mainframe Modernization managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.resource.m2_non_managed_application

The AWS Mainframe Modernization non-managed application in the mainframe resource summary.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input.resource.m2_non_managed_application.listener_port

The listener port of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.resource.m2_non_managed_application.runtime

The runtime of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.resource.m2_non_managed_application.vpc_endpoint_service_name

The VPC endpoint service name of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.resource.m2_non_managed_application.web_app_name

The web application name of the AWS Mainframe Modernization non-managed application summary.

step_run_summary.mainframe_action.tn3270.step_input.script

The script of the TN3270 step input.

Show child fields
step_run_summary.mainframe_action.tn3270.step_input.script.script_location

The script location of the script summary.

step_run_summary.mainframe_action.tn3270.step_input.script.type

The type of the script summary.

step_run_summary.mainframe_action.tn3270.step_output

The step output of the TN3270 summary.

Show child fields
step_run_summary.mainframe_action.tn3270.step_output.data_set_details[]
Show child fields
step_run_summary.mainframe_action.tn3270.step_output.data_set_details[].ccsid

The CCSID of the data set.

step_run_summary.mainframe_action.tn3270.step_output.data_set_details[].format

The format of the data set.

step_run_summary.mainframe_action.tn3270.step_output.data_set_details[].length

The length of the data set.

step_run_summary.mainframe_action.tn3270.step_output.data_set_details[].name

The name of the data set.

step_run_summary.mainframe_action.tn3270.step_output.data_set_details[].type

The type of the data set.

step_run_summary.mainframe_action.tn3270.step_output.data_set_export_location

The data set export location of the TN3270 step output.

step_run_summary.mainframe_action.tn3270.step_output.dms_output_location

The output location of the TN3270 step output.

step_run_summary.mainframe_action.tn3270.step_output.script_output_location

The script output location of the TN3270 step output.

step_run_summary.resource_action

The resource action of the step run summary.

Show child fields
step_run_summary.resource_action.cloud_formation

The CloudFormation template of the resource action summary.

Show child fields
step_run_summary.resource_action.cloud_formation.create_cloudformation

Creates the CloudFormation summary of the step.

Show child fields
step_run_summary.resource_action.cloud_formation.create_cloudformation.step_input

The step input of the CloudFormation summary.

Show child fields
step_run_summary.resource_action.cloud_formation.create_cloudformation.step_input.parameters

The CloudFormation properties of the CloudFormation step input.

step_run_summary.resource_action.cloud_formation.create_cloudformation.step_input.template_location

The template location of the CloudFormation step input.

step_run_summary.resource_action.cloud_formation.create_cloudformation.step_output

The step output of the CloudFormation summary.

Show child fields
step_run_summary.resource_action.cloud_formation.create_cloudformation.step_output.exports

The exports of the CloudFormation step output.

step_run_summary.resource_action.cloud_formation.create_cloudformation.step_output.stack_id

The stack ID of the CloudFormation step output.

step_run_summary.resource_action.cloud_formation.delete_cloudformation

Deletes the CloudFormation summary of the CloudFormation step summary.

Show child fields
step_run_summary.resource_action.cloud_formation.delete_cloudformation.step_input

The step input of the deleted CloudFormation summary.

Show child fields
step_run_summary.resource_action.cloud_formation.delete_cloudformation.step_input.stack_id

The stack ID of the deleted CloudFormation step input.

step_run_summary.resource_action.cloud_formation.delete_cloudformation.step_output

The step output of the deleted CloudFormation summary.

step_run_summary.resource_action.m2_managed_application

The AWS Mainframe Modernization managed application of the resource action summary.

Show child fields
step_run_summary.resource_action.m2_managed_application.step_input

The step input of the AWS Mainframe Modernization managed application step summary.

Show child fields
step_run_summary.resource_action.m2_managed_application.step_input.action_type

The action type of the AWS Mainframe Modernization managed application step input.

step_run_summary.resource_action.m2_managed_application.step_input.application_id

The application ID of the AWS Mainframe Modernization managed application step input.

step_run_summary.resource_action.m2_managed_application.step_input.listener_port

The listener port of the AWS Mainframe Modernization managed application step input.

step_run_summary.resource_action.m2_managed_application.step_input.properties

The properties of the AWS Mainframe Modernization managed application step input.

Show child fields
step_run_summary.resource_action.m2_managed_application.step_input.properties.force_stop

Force stops the AWS Mainframe Modernization managed action properties.

step_run_summary.resource_action.m2_managed_application.step_input.properties.import_data_set_location

The import data set location of the AWS Mainframe Modernization managed action properties.

step_run_summary.resource_action.m2_managed_application.step_input.runtime

The runtime of the AWS Mainframe Modernization managed application step input.

step_run_summary.resource_action.m2_managed_application.step_input.vpc_endpoint_service_name

The VPC endpoint service name of the AWS Mainframe Modernization managed application step input.

step_run_summary.resource_action.m2_managed_application.step_output

The step output of the AWS Mainframe Modernization managed application step summary.

Show child fields
step_run_summary.resource_action.m2_managed_application.step_output.import_data_set_summary

The import data set summary of the AWS Mainframe Modernization managed application step output.

step_run_summary.resource_action.m2_non_managed_application

The AWS Mainframe Modernization non-managed application of the resource action summary.

Show child fields
step_run_summary.resource_action.m2_non_managed_application.step_input

The step input of the AWS Mainframe Modernization non-managed application step summary.

Show child fields
step_run_summary.resource_action.m2_non_managed_application.step_input.action_type

The action type of the AWS Mainframe Modernization non-managed application step input.

step_run_summary.resource_action.m2_non_managed_application.step_input.listener_port

The listener port of the AWS Mainframe Modernization non-managed application step input.

step_run_summary.resource_action.m2_non_managed_application.step_input.runtime

The runtime of the AWS Mainframe Modernization non-managed application step input.

step_run_summary.resource_action.m2_non_managed_application.step_input.vpc_endpoint_service_name

The VPC endpoint service name of the AWS Mainframe Modernization non-managed application step input.

step_run_summary.resource_action.m2_non_managed_application.step_input.web_app_name

The web app name of the AWS Mainframe Modernization non-managed application step input.

step_run_summary.resource_action.m2_non_managed_application.step_output

The step output of the AWS Mainframe Modernization non-managed application step summary.

test_case_version

The test case version of the test run step.

BIGINT
test_suite_version

The test suite version of the test run step.

BIGINT