| Column Name | Column Data Type |
|---|
network_id Required Input Column
The unique identifier of the network for which the proposal is made. | VARCHAR |
proposal_id Required Input Column
The unique identifier of the proposal. | 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 |
proposal
Information about a proposal. | STRUCT(
"proposal_id" VARCHAR,
"network_id" VARCHAR,
"description" VARCHAR,
"actions" STRUCT(
"invitations" STRUCT(
"principal" VARCHAR
)[],
"removals" STRUCT(
"member_id" VARCHAR
)[]
),
"proposed_by_member_id" VARCHAR,
"proposed_by_member_name" VARCHAR,
"status" VARCHAR,
"creation_date" TIMESTAMP_S,
"expiration_date" TIMESTAMP_S,
"yes_vote_count" BIGINT,
"no_vote_count" BIGINT,
"outstanding_vote_count" BIGINT,
"tags" MAP(VARCHAR, VARCHAR),
"arn" VARCHAR
) |
Show child fields- proposal.actions
The actions to perform on the network if the proposal is APPROVED. Show child fields- proposal.actions.invitations[]
Show child fields- proposal.actions.invitations[].principal
The Amazon Web Services account ID to invite.
- proposal.actions.removals[]
Show child fields- proposal.actions.removals[].member_id
The unique identifier of the member to remove.
- proposal.arn
The Amazon Resource Name (ARN) of the proposal. For more information about ARNs and their format, see Amazon Resource Names (ARNs) in the Amazon Web Services General Reference. - proposal.creation_date
The date and time that the proposal was created. - proposal.description
The description of the proposal. - proposal.expiration_date
The date and time that the proposal expires. This is the CreationDate plus the ProposalDurationInHours that is specified in the ProposalThresholdPolicy. After this date and time, if members haven't cast enough votes to determine the outcome according to the voting policy, the proposal is EXPIRED and Actions aren't carried out. - proposal.network_id
The unique identifier of the network for which the proposal is made. - proposal.no_vote_count
The current total of NO votes cast on the proposal by members. - proposal.outstanding_vote_count
The number of votes remaining to be cast on the proposal by members. In other words, the number of members minus the sum of YES votes and NO votes. - proposal.proposal_id
The unique identifier of the proposal. - proposal.proposed_by_member_id
The unique identifier of the member that created the proposal. - proposal.proposed_by_member_name
The name of the member that created the proposal. - proposal.status
The status of the proposal. Values are as follows: -
IN_PROGRESS - The proposal is active and open for member voting. -
APPROVED - The proposal was approved with sufficient YES votes among members according to the VotingPolicy specified for the Network. The specified proposal actions are carried out. -
REJECTED - The proposal was rejected with insufficient YES votes among members according to the VotingPolicy specified for the Network. The specified ProposalActions aren't carried out. -
EXPIRED - Members didn't cast the number of votes required to determine the proposal outcome before the proposal expired. The specified ProposalActions aren't carried out. -
ACTION_FAILED - One or more of the specified ProposalActions in a proposal that was approved couldn't be completed because of an error. The ACTION_FAILED status occurs even if only one ProposalAction fails and other actions are successful. - proposal.tags
Tags assigned to the proposal. Each tag consists of a key and optional value. For more information about tags, see Tagging Resources in the Amazon Managed Blockchain Ethereum Developer Guide, or Tagging Resources in the Amazon Managed Blockchain Hyperledger Fabric Developer Guide. - proposal.yes_vote_count
The current total of YES votes cast on the proposal by members.
|