| Column Name | Column Data Type |
|---|
consumer_arn Input Column
The Amazon Resource Name (ARN) of the consumer namespace that returns in the list of datashares. | VARCHAR |
status Input Column
An identifier giving the status of a datashare in the consumer cluster. If this field is specified, Amazon Redshift returns the list of datashares that have the specified status. | 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.
|
_aws_region Input Column
The AWS region to use. | VARCHAR |
allow_publicly_accessible_consumers
A value that specifies whether the datashare can be shared to a publicly accessible cluster. | BOOLEAN |
data_share_arn
The Amazon Resource Name (ARN) of the datashare that the consumer is to use. | VARCHAR |
data_share_associations
A value that specifies when the datashare has an association between producer and data consumers. | STRUCT(
"consumer_identifier" VARCHAR,
"status" VARCHAR,
"consumer_region" VARCHAR,
"created_date" TIMESTAMP_S,
"status_change_date" TIMESTAMP_S,
"producer_allowed_writes" BOOLEAN,
"consumer_accepted_writes" BOOLEAN
)[] |
Show child fields- data_share_associations[]
Show child fields- data_share_associations[].consumer_accepted_writes
Specifies whether write operations were allowed during data share association. - data_share_associations[].consumer_identifier
The name of the consumer accounts that have an association with a producer datashare. - data_share_associations[].consumer_region
The Amazon Web Services Region of the consumer accounts that have an association with a producer datashare. - data_share_associations[].created_date
The creation date of the datashare that is associated. - data_share_associations[].producer_allowed_writes
Specifies whether write operations were allowed during data share authorization. - data_share_associations[].status
The status of the datashare that is associated. - data_share_associations[].status_change_date
The status change data of the datashare that is associated.
|
managed_by
The identifier of a datashare to show its managing entity. | VARCHAR |
producer_arn
The Amazon Resource Name (ARN) of the producer namespace. | VARCHAR |