Skip to content

aws.ram.list_replace_permission_associations_work

Example SQL Queries

SELECT * FROM
aws.ram.list_replace_permission_associations_work;

Description

Retrieves the current status of the asynchronous tasks performed by RAM when you perform the ReplacePermissionAssociationsWork operation.

Table Definition

Column NameColumn Data Type
max_results Input Column

Specifies the total number of results that you want included on each page of the response. If you do not include this parameter, it defaults to a value that is specific to the operation. If additional items exist beyond the number you specify, the NextToken response element is returned with a value (not null). Include the specified value as the NextToken request parameter in the next call to the operation to get the next part of the results. Note that the service might return fewer results than the maximum even when there are more results available. You should check NextToken after every operation to ensure that you receive all of the results.

BIGINT
next_token Input Column

If present, this value indicates that more output is available than is included in the current response. Use this value in the NextToken request parameter in a subsequent call to the operation to get the next part of the output. You should repeat this until the NextToken response element comes back as null. This indicates that this is the last page of results.

VARCHAR
status Input Column

Specifies that you want to see only the details about requests with a status that matches this value.

VARCHAR
work_ids Input Column

A list of IDs. These values come from the idfield of the replacePermissionAssociationsWorkstructure returned by the ReplacePermissionAssociations operation.

VARCHAR[]
Show child fields
work_ids[]
_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
replace_permission_associations_works

An array of data structures that provide details of the matching work IDs.

STRUCT(
"id" VARCHAR,
"from_permission_arn" VARCHAR,
"from_permission_version" VARCHAR,
"to_permission_arn" VARCHAR,
"to_permission_version" VARCHAR,
"status" VARCHAR,
"status_message" VARCHAR,
"creation_time" TIMESTAMP_S,
"last_updated_time" TIMESTAMP_S
)[]
Show child fields
replace_permission_associations_works[]
Show child fields
replace_permission_associations_works[].creation_time

The date and time when this asynchronous background task was created.

replace_permission_associations_works[].from_permission_arn

The Amazon Resource Name (ARN) of the managed permission that this background task is replacing.

replace_permission_associations_works[].from_permission_version

The version of the managed permission that this background task is replacing.

replace_permission_associations_works[].id

The unique identifier for the background task associated with one ReplacePermissionAssociations request.

replace_permission_associations_works[].last_updated_time

The date and time when the status of this background task was last updated.

replace_permission_associations_works[].status

Specifies the current status of the background tasks for the specified ID. The output is one of the following strings:

  • IN_PROGRESS

  • COMPLETED

  • FAILED

replace_permission_associations_works[].status_message

Specifies the reason for a FAILED status. This field is present only when there status is FAILED.

replace_permission_associations_works[].to_permission_arn

The ARN of the managed permission that this background task is associating with the resource shares in place of the managed permission and version specified in fromPermissionArn and fromPermissionVersion.

replace_permission_associations_works[].to_permission_version

The version of the managed permission that this background task is associating with the resource shares. This is always the version that is currently the default for this managed permission.