Skip to content
AWS for Query.Farm

aws.managedblockchain_query.list_transaction_events

Example SQL Queries

SELECT * FROM
aws.managedblockchain_query.list_transaction_events
WHERE
"network" = 'VALUE';

Description

Lists all the transaction events for a transaction

This action will return transaction details for all transactions that are confirmed on the blockchain, even if they have not reached finality.

Table Definition

Column NameColumn Data Type
network Required Input Column

The blockchain network where the transaction occurred.

VARCHAR
transaction_hash Input Column

The hash of a transaction. It is generated when a transaction is created.

VARCHAR
transaction_id Input Column

The identifier of a Bitcoin transaction. It is generated when a transaction is created.

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
blockchain_instant

The container for time.

STRUCT(
    "time" TIMESTAMP_S
)
Show child fields
blockchain_instant.time

The container of the Timestamp of the blockchain instant.

This timestamp will only be recorded up to the second.

confirmation_status

This container specifies whether the transaction has reached Finality.

VARCHAR
contract_address

The blockchain address for the contract

VARCHAR
event_type

The type of transaction event.

VARCHAR
from

The wallet address initiating the transaction. It can either be a public key or a contract.

VARCHAR
spent_vout_index

The position of the spent transaction output in the output list of the creating transaction.

This is only returned for BITCOIN_VIN event types.

BIGINT
spent_vout_transaction_hash

The transactionHash that created the spent transaction output.

This is only returned for BITCOIN_VIN event types.

VARCHAR
spent_vout_transaction_id

The transactionId that created the spent transaction output.

This is only returned for BITCOIN_VIN event types.

VARCHAR
to

The wallet address receiving the transaction. It can either be a public key or a contract.

VARCHAR
token_id

The unique identifier for the token involved in the transaction.

VARCHAR
value

The value that was transacted.

VARCHAR
vout_index

The position of the transaction output in the transaction output list.

BIGINT
vout_spent

Specifies if the transaction output is spent or unspent. This is only returned for BITCOIN_VOUT event types.

This is only returned for BITCOIN_VOUT event types.

BOOLEAN