solana.account_activity
table has been updated to a new version. The new version of the table contains additional information around token activity. The following columns were added to the table:pre_token_balances
post_token_balances
token_balance_changes
solana.account_activity
table that contains all of the information about an account’s usage in a transaction.solana.transactions
table has now been upgraded to a new version. The new version of the table uses cleaner array structs to make it easier to extract useful information.solana.vote_transactions
, so queries using solana.transactions
will have better performance. Unfortunately, the table change also means that some existing queries will now break and need to be changed.solana.transactions
:WHERE ARRAY_CONTAINS(account_keys, "Vote111111111111111111111111111111111111111") = false
error_index
and error_message
columns have been removed, and have been merged into the error
column (which is a struct). So now instead of WHERE error_index is not null
, a query should do WHERE error is not null
.account_keys
now include the account address directly, so there is no need to use the account_keys
column to look up the account addresses:pre_token_balances
and post_token_balances
columns have changed. The token balance is now included in the field amount
. And as mentioned above, the struct in the array now has a field account
, which is the account of the token balance.instructions
column has changed. As mentioned above, the struct in the array now has a field executing_account
, which is the account executing the instruction.inner_instructions
column is removed, and inner instructions have been moved into the instructions
column.