Table: aws_ram_resource_association

AWS Resource Access Manager (RAM) helps you securely share the AWS resources you create in one AWS account with other AWS accounts. If you have multiple AWS accounts, you can create a resource once and use AWS RAM to make that resource usable by those other accounts.

Examples

Basic info

select
  resource_share_name,
  resource_share_arn,
  associated_entity,
  status
from
  aws_ram_resource_association;

List permissions attached with each shared resource associated

select
  resource_share_name,
  resource_share_arn,
  associated_entity,
  p ->> 'Arn' as resource_share_permission_arn,
  p ->> 'Status' as resource_share_permission_status
from
  aws_ram_resource_association,
  jsonb_array_elements(resource_share_permission) p;

Get resources that failed association

select
  resource_share_name,
  resource_share_arn,
  associated_entity,
  status
from
  aws_ram_resource_association
where
  status = 'FAILED';

Control examples

.inspect aws_ram_resource_association

AWS RAM Resource Association

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
associated_entity	text	The Amazon Resoure Name (ARN) of the associated resource.
association_type	text	The type of entity included in this association.
creation_time	timestamp with time zone	The date and time when the association was created.
external	boolean	Indicates whether the principal belongs to the same organization in Organizations as the Amazon Web Services account that owns the resource share.
last_updated_time	timestamp with time zone	The date and time when the association was last updated..
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
resource_share_arn	text	The Amazon Resoure Name (ARN) of the resource share.
resource_share_name	text	The name of the resource share.
resource_share_permission	jsonb	Information about an RAM permission that is associated with a resource share and any of its resources of a specified type.
status	text	The current status of the association.
status_message	text	A message about the status of the association.
title	text	Title of the resource.

turbot/aws