Skip to content
AWS for Query.Farm

aws.marketplace_catalog.list_change_sets

Example SQL Queries

SELECT * FROM
aws.marketplace_catalog.list_change_sets
WHERE
"catalog" = 'VALUE';

Description

Returns the list of change sets owned by the account being used to make the call. You can filter this list by providing any combination of entityId, ChangeSetName, and status. If you provide more than one filter, the API operation applies a logical AND between the filters.

You can describe a change during the 60-day request history retention period for API calls.

Table Definition

Column NameColumn Data Type
catalog Required Input Column

The catalog related to the request. Fixed value: AWSMarketplace 

VARCHAR
filter_list Input Column

An array of filter objects.

STRUCT(
    "name" VARCHAR,
    "value_list" VARCHAR[]
)[]
Show child fields
filter_list[]
Show child fields
filter_list[].name

For ListEntities, the supported value for this is an EntityId.

For ListChangeSets, the supported values are as follows:

filter_list[].value_list[]
sort Input Column

An object that contains two attributes, SortBy and SortOrder.

STRUCT(
    "sort_by" VARCHAR,
    "sort_order" VARCHAR
)
Show child fields
sort.sort_by

For ListEntities, supported attributes include LastModifiedDate (default) and EntityId. In addition to LastModifiedDate and EntityId, each EntityType might support additional fields.

For ListChangeSets, supported attributes include StartTime and EndTime.

sort.sort_order

The sorting order. Can be ASCENDING or DESCENDING. The default value is DESCENDING.

_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_arn

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

VARCHAR
change_set_id

The unique identifier for a change set.

VARCHAR
change_set_name

The non-unique name for the change set.

VARCHAR
end_time

The time, in ISO 8601 format (2018-02-27T13:45:22Z), when the change set was finished.

VARCHAR
entity_id_list

This object is a list of entity IDs (string) that are a part of a change set. The entity ID list is a maximum of 20 entities. It must contain at least one entity.

VARCHAR[]
Show child fields
entity_id_list[]
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 of DescribeChangeSet), or SERVER_FAULT, which means that there is a problem in the system, and you should retry your request.

VARCHAR
start_time

The time, in ISO 8601 format (2018-02-27T13:45:22Z), when the change set was started.

VARCHAR
status

The current status of the change set.

VARCHAR