Skip to content
AWS for Query.Farm

aws.managedblockchain.get_accessor

Example SQL Queries

SELECT * FROM
aws.managedblockchain.get_accessor
WHERE
"accessor_id" = 'VALUE';

Description

Returns detailed information about an accessor. An accessor object is a container that has the information required for token based access to your Ethereum nodes.

Table Definition

Column NameColumn Data Type
accessor_id Required Input Column

The unique identifier of the accessor.

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
accessor

The properties of the accessor.

STRUCT(
    "id" VARCHAR,
    "type" VARCHAR,
    "billing_token" VARCHAR,
    "status" VARCHAR,
    "creation_date" TIMESTAMP_S,
    "arn" VARCHAR,
    "tags" MAP(VARCHAR, VARCHAR),
    "network_type" VARCHAR
)
Show child fields
accessor.arn

The Amazon Resource Name (ARN) of the accessor. For more information about ARNs and their format, see Amazon Resource Names (ARNs) in the Amazon Web Services General Reference.

accessor.billing_token

The billing token is a property of the Accessor. Use this token to when making calls to the blockchain network. The billing token is used to track your accessor token for billing requests.

accessor.creation_date

The creation date and time of the accessor.

accessor.id

The unique identifier of the accessor.

accessor.network_type

The blockchain network that the Accessor token is created for.

accessor.status

The current status of the accessor.

accessor.tags

The tags assigned to the Accessor.

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.

accessor.type

The type of the accessor.

Currently, accessor type is restricted to BILLING_TOKEN.