Skip to content
AWS for Query.Farm

aws.migration_hub_refactor_spaces.list_services

Example SQL Queries

SELECT * FROM
aws.migration_hub_refactor_spaces.list_services
WHERE
"application_identifier" = 'VALUE'
AND "environment_identifier" = 'VALUE';

Description

Lists all the Amazon Web Services Migration Hub Refactor Spaces services within an application.

Table Definition

Column NameColumn Data Type
application_identifier Required Input Column

The ID of the application. 

VARCHAR
environment_identifier Required Input Column

The ID of the environment. 

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.

application_id

The unique identifier of the application. 

VARCHAR
arn

The Amazon Resource Name (ARN) of the service. 

VARCHAR
created_by_account_id

The Amazon Web Services account ID of the service creator. 

VARCHAR
created_time

A timestamp that indicates when the service is created. 

TIMESTAMP_S
description

A description of the service. 

VARCHAR
endpoint_type

The endpoint type of the service. 

VARCHAR
environment_id

The unique identifier of the environment. 

VARCHAR
error

Any error associated with the service resource. 

STRUCT(
    "account_id" VARCHAR,
    "additional_details" MAP(VARCHAR, VARCHAR),
    "code" VARCHAR,
    "message" VARCHAR,
    "resource_identifier" VARCHAR,
    "resource_type" VARCHAR
)
Show child fields
error.account_id

The Amazon Web Services account ID of the resource owner.

error.additional_details

Additional details about the error.

error.code

The error code associated with the error.

error.message

The message associated with the error.

error.resource_identifier

The ID of the resource.

error.resource_type

The type of resource.

lambda_endpoint

A summary of the configuration for the Lambda endpoint type. 

STRUCT(
    "arn" VARCHAR
)
Show child fields
lambda_endpoint.arn

The Amazon Resource Name (ARN) of the Lambda endpoint.

last_updated_time

A timestamp that indicates when the service was last updated. 

TIMESTAMP_S
name

The name of the service. 

VARCHAR
owner_account_id

The Amazon Web Services account ID of the service owner.

VARCHAR
service_id

The unique identifier of the service. 

VARCHAR
state

The current state of the service. 

VARCHAR
tags

The tags assigned to the service. 

MAP(VARCHAR, VARCHAR)
url_endpoint

The summary of the configuration for the URL endpoint type. 

STRUCT(
    "health_url" VARCHAR,
    "url" VARCHAR
)
Show child fields
url_endpoint.health_url

The health check URL of the URL endpoint type. If the URL is a public endpoint, the HealthUrl must also be a public endpoint. If the URL is a private endpoint inside a virtual private cloud (VPC), the health URL must also be a private endpoint, and the host must be the same as the URL.

url_endpoint.url

The URL to route traffic to. The URL must be an rfc3986-formatted URL. If the host is a domain name, the name must be resolvable over the public internet. If the scheme is https, the top level domain of the host must be listed in the IANA root zone database.

vpc_id

The ID of the virtual private cloud (VPC). 

VARCHAR