Table Details
| Property | Value |
|---|---|
| Table Name | solana.raw.voting_sol_balances |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, txn_id, unique_id |
| Clustering Key(s) | to_date("block_timestamp"), "success", "address_short" |
| Search Optimization | txn_id, signer, success, address_short |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(134217728) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| raw_amount | VARCHAR(134217728) | Token amount in the smallest indivisible unit (not decimal-adjusted). Same concept as amount_raw — the column is named raw_amount in models that follow the raw_ prefix convention. |
| pre_raw_amount | VARCHAR(134217728) | Raw token balance before a transfer, in native units without decimal adjustment. |
| signer | VARCHAR(16777216) | Primary signing account (fee payer) of the transaction. This is the account that authorized the transaction and paid transaction fees. |
| 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 |
| 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_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| 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. |
| unique_id | VARCHAR(134217728) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| address_short | VARCHAR(16777216) | Abbreviated address (first 8 characters) for display purposes. |