Skip to content
AWS for Query.Farm

aws.migrationhuborchestrator.list_workflow_steps

Example SQL Queries

SELECT * FROM
aws.migrationhuborchestrator.list_workflow_steps
WHERE
"workflow_id" = 'VALUE'
AND "step_group_id" = 'VALUE';

Description

List the steps in a workflow.

Table Definition

Column NameColumn Data Type
step_group_id Required Input Column

The ID of the step group.

VARCHAR
workflow_id Required Input Column

The ID of the migration 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.

description

The description of the step.

VARCHAR
name

The name of the step.

VARCHAR
next

The next step.

VARCHAR[]
Show child fields
next[]
no_of_srv_completed

The number of servers that have been migrated.

BIGINT
no_of_srv_failed

The number of servers that have failed to migrate.

BIGINT
owner

The owner of the step.

VARCHAR
previous

The previous step.

VARCHAR[]
Show child fields
previous[]
script_location

The location of the script.

VARCHAR
status

The status of the step.

VARCHAR
status_message

The status message of the migration workflow.

VARCHAR
step_action_type

The action type of the step. You must run and update the status of a manual step for the workflow to continue after the completion of the step.

VARCHAR
step_id

The ID of the step.

VARCHAR
total_no_of_srv

The total number of servers that have been migrated.

BIGINT