Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | solana_devnet.raw.transactions |
| Table Status | Beta 🌱 |
| Unique Key | txn_id |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | txn_id, txn_index, signatures, signer, is_voting |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_slot | NUMBER(38,0) | Slot of the block containing this transaction. |
| block_height | NUMBER(38,0) | Height of the block containing this transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Estimated production time of the containing block, as Unix timestamp. |
| block_hash | VARCHAR(16777216) | Blockhash of the containing block. |
| txn_id | VARCHAR(16777216) | The transaction signature (unique identifier). |
| txn_index | NUMBER(38,0) | Position of this transaction within its block. |
| signatures | VARIANT | List of all signatures on this transaction (first is the fee payer’s). |
| fee | NUMBER(38,0) | Transaction fee in lamports. |
| err | VARCHAR(16777216) | Error information if the transaction failed, null on success. |
| account_keys | VARIANT | List of all account addresses referenced by the transaction (in order). |
| recent_block_hash | VARCHAR(16777216) | Recent blockhash used to anchor this transaction in time and prevent replay. |
| signer | VARCHAR(16777216) | The primary signer (fee payer) of the transaction. |
| log_messages | VARIANT | Array of program log messages emitted during execution. |
| pre_token_balances | VARIANT | SPL token balances of relevant accounts before the transaction. |
| post_token_balances | VARIANT | SPL token balances of relevant accounts after the transaction. |
| pre_balances | VARIANT | SOL balances (in lamports) of accounts before the transaction. |
| post_balances | VARIANT | SOL balances (in lamports) of accounts after the transaction. |
| success | BOOLEAN | True if the transaction succeeded (err is null). |
| is_voting | BOOLEAN | True if this is a consensus vote transaction. |
| instruction_count | NUMBER(38,0) | Number of top-level instructions in the transaction. |
| mint_to_decimals | VARIANT | Map from SPL token mint address to its decimal precision for tokens involved. |
| token_accounts | VARIANT | List of token account addresses involved in the transaction. |
| sol_amounts | VARIANT | Map of SOL balance deltas (lamports) per account index. |
| _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. |