| block_slot | NUMBER(38,0) | Solana slot number in which this transaction was confirmed. Slots are the fundamental unit of time on Solana (analogous to block numbers on EVM chains). Not every slot produces a block. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| txn_id | VARCHAR(16777216) | Base58-encoded transaction signature on Solana. Analogous to transaction_hash on EVM chains. Uniquely identifies a transaction. |
| txn_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| signatures | VARIANT | Array of cryptographic signatures authorizing this transaction. |
| fee | NUMBER(38,0) | Fee tier of the liquidity pool, expressed in hundredths of a basis point (e.g. 3000 = 0.3%). Paid by traders to liquidity providers on each swap. |
| err | VARCHAR(16777216) | Error details if this transaction failed, NULL for successful transactions |
| account_keys | VARIANT | Array of public key addresses of all accounts accessed by this Solana transaction |
| recent_block_hash | VARCHAR(16777216) | Recent block hash included in this transaction to prevent replay attacks |
| signer | VARCHAR(16777216) | Primary signing account (fee payer) of the transaction. This is the account that authorized the transaction and paid transaction fees. |
| log_messages | VARIANT | Array of program log messages emitted during transaction execution |
| pre_token_balances | VARIANT | Array of SPL token balances for all accounts before this transaction executed |
| post_token_balances | VARIANT | Array of SPL token balances for all accounts after this transaction executed |
| pre_balances | VARIANT | Array of account balances in lamports before this transaction executed |
| post_balances | VARIANT | Array of account balances in lamports after all instructions in this transaction executed |
| success | BOOLEAN | Boolean flag indicating whether the transaction executed successfully. True = succeeded, false = failed or reverted. |
| is_voting | BOOLEAN | True if this transaction is a validator vote transaction |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| instruction_count | NUMBER(38,0) | Number of top-level instructions in this transaction |
| mint_to_decimals | VARIANT | Number of decimal places for the token mint involved in this transfer |
| token_accounts | VARIANT | Array of SPL token account addresses involved in this transaction |
| sol_amounts | VARIANT | Array of SOL amount changes per account resulting from this transaction |
| compute_units_consumed | NUMBER(38,0) | Actual compute units used by this transaction or instruction execution. |
| _extra_fields | VARIANT | JSON string with platform-specific metadata. |
