Skip to content
AWS for Query.Farm

aws.marketplace_catalog.describe_change_set

Example SQL Queries

SELECT * FROM
aws.marketplace_catalog.describe_change_set
WHERE
"catalog" = 'VALUE'
AND "change_set_id" = 'VALUE';

Description

Provides information about a given change set.

Table Definition

Column NameColumn Data Type
catalog Required Input Column

Required. The catalog related to the request. Fixed value: AWSMarketplace 

VARCHAR
change_set_id Required Input Column

Required. The unique identifier for the change set referenced in this request.

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.

change_set

An array of ChangeSummary objects.

STRUCT(
    "change_type" VARCHAR,
    "entity" STRUCT(
        "type" VARCHAR,
        "identifier" VARCHAR
    ),
    "details" VARCHAR,
    "details_document" VARCHAR,
    "error_detail_list" STRUCT(
        "error_code" VARCHAR,
        "error_message" VARCHAR
    )[],
    "change_name" VARCHAR
)[]
Show child fields
change_set[]
Show child fields
change_set[].change_name

Optional name for the change.

change_set[].change_type

The type of the change.

change_set[].details

This object contains details specific to the change type of the requested change.

change_set[].details_document

The JSON value of the details specific to the change type of the requested change.

change_set[].entity

The entity to be changed.

Show child fields
change_set[].entity.identifier

The identifier for the entity.

change_set[].entity.type

The type of entity.

change_set[].error_detail_list[]
Show child fields
change_set[].error_detail_list[].error_code

The error code that identifies the type of error.

change_set[].error_detail_list[].error_message

The message for the error.

change_set_arn

The ARN associated with the unique identifier for the change set referenced in this request.

VARCHAR
change_set_name

The optional name provided in the StartChangeSet request. If you do not provide a name, one is set by default.

VARCHAR
end_time

The date and time, in ISO 8601 format (2018-02-27T13:45:22Z), the request transitioned to a terminal state. The change cannot transition to a different state. Null if the request is not in a terminal state. 

VARCHAR
failure_code

Returned if the change set is in FAILED status. Can be either CLIENT_ERROR, which means that there are issues with the request (see the ErrorDetailList), or SERVER_FAULT, which means that there is a problem in the system, and you should retry your request.

VARCHAR
failure_description

Returned if there is a failure on the change set, but that failure is not related to any of the changes in the request.

VARCHAR
intent

The optional intent provided in the StartChangeSet request. If you do not provide an intent, APPLY is set by default.

VARCHAR
start_time

The date and time, in ISO 8601 format (2018-02-27T13:45:22Z), the request started. 

VARCHAR
status

The status of the change request.

VARCHAR