Priced Transfers Failed Table
Contains information about failed priced transfers within the Solana network, aiding in the analysis of transaction failures and associated details.
Name
Type
Description
BLOCK_SLOT
FIXED
Slot number or identifier of the block.
TIMESTAMP
FIXED
Raw value of the time in Unix Epoch time (in UTC time zone), which is then converted to DATETIME column.
DATETIME
TIMESTAMP_NTZ
Timestamp of the transaction in UTC.
BLOCK_HASH
TEXT
The hash of a specific block in the chain.
TRANSACTION_INDEX
FIXED
The position or order of a transaction within a block of the blockchain.
TRANSACTION_ID
TEXT
Unique identifier assigned to each transaction within the blockchain.
INSTRUCTION_INDEX
FIXED
Index of the instruction within a transaction.
INNER_INSTRUCTION_INDEX
FIXED
Index of inner instruction within a transaction.
PROGRAM
TEXT
Program or smart contract associated with the instruction.
PROGRAM_ID
TEXT
The program ID of the instruction.
TYPE
TEXT
The type of the transfer.
ACCOUNT_AUTHORITY
TEXT
The authority address that is assigned to the account.
SIGNERS
VARIANT
List of signers associated with the instruction.
FROM_ACCOUNT_OWNER
TEXT
The owner address of the from account.
FROM_ACCOUNT_SOURCE
TEXT
The source address of the from account.
FROM_ACCOUNT
TEXT
The projected highest level from account owner based on owner, authority, and source fields in this order.
TO_ACCOUNT_OWNER
TEXT
The owner address of the to account.
TO_ACCOUNT_DESTINATION
TEXT
The source address of the to account.
TO_ACCOUNT
TEXT
The projected highest level to_account owner based on owner and destination fields in this order.
TOKEN_ADDRESS
TEXT
The address of the token.
NAME
TEXT
The name of the token being searched.
SYMBOL
TEXT
The symbol of the token being searched.
VALUE
REAL
The curated quantity of the token. A negative value indicates the token is being sent out. A positive value indicates the token is being received.
TOKEN_FEE
REAL
The fee or royalties associated to the token account.
USD_VALUE
REAL
The curated value of the token, priced in USD.
USD_TOKEN_FEE
REAL
The token fee priced in USD.
SOURCE_VALUE
FIXED
The raw quantity of the token before the decimal conversion.
SOURCE_TOKEN_FEE
FIXED
The raw quantity of the token before the decimal conversion.
DATE_CREATED
TIMESTAMP_NTZ
Indicates the date in which the data was loaded.
DATE_UPDATED
TIMESTAMP_NTZ
Indicates the date in which the data was updated.
🔍 Use these columns to analyze failed priced transfers and diagnose potential issues, identifying which program was involved, the block and transaction where the failure occurred, and any relevant authority or signers associated with the account, among others. You can:
Identify the block and transaction context using
BLOCK_SLOT
,TIMESTAMP
,DATETIME
,BLOCK_HASH
,TRANSACTION_INDEX
, andTRANSACTION_ID
.Pinpoint the specific instruction with
INSTRUCTION_INDEX
andINNER_INSTRUCTION_INDEX
.Examine transfer details by reviewing
PROGRAM,
PROGRAM_ID
, andTYPE
.Understand account involvement with
ACCOUNT_AUTHORITY
andSIGNERS
.Analyze participating accounts via
FROM_ACCOUNT_OWNER
,FROM_ACCOUNT_SOURCE
,FROM_ACCOUNT
,TO_ACCOUNT_OWNER
,TO_ACCOUNT_DESTINATION
, andTO_ACCOUNT
.Retrieve token identity and characteristics using
TOKEN_ADDRESS
,NAME
, andSYMBOL
.Evaluate the attempted transfer amount and fee structure with
VALUE
,TOKEN_FEE
,USD_VALUE
,USD_TOKEN_FEE
,SOURCE_VALUE
, andSOURCE_TOKEN_FEE
.Monitor data recency using
DATE_CREATED
andDATE_UPDATED
.
💡 For example, you might query VALUE,
USD_VALUE
, and FROM_ACCOUNT
to assess the scale of a failed transfer and determine the context of the failure, along with other key parameters.
Last updated