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 | casper.raw.transactions |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, block_height, hash |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | hash, block_height, initiator |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR(16777216) | Hash of the transaction. |
| transaction_index | NUMBER(38,0) | Index of the transaction within the block. |
| transaction_result | VARCHAR(16777216) | Execution result of the transaction (e.g., Success or Failure). |
| initiator | VARCHAR(16777216) | Account that signed and initiated the transaction. |
| cost | VARCHAR(16777216) | Total motes charged for the transaction. |
| gas_price | NUMBER(38,0) | Per-transaction gas price tolerance (Version1); null for legacy Deploy transactions. |
| gas_consumed | VARCHAR(16777216) | Computational gas units consumed during execution. |
| gas_limit | VARCHAR(16777216) | Maximum gas units the transaction is allowed to consume. |
| gas_refund | VARCHAR(16777216) | Motes refunded to the initiator after execution. |
| current_price | NUMBER(38,0) | Block-level current gas price active when the transaction was included. |
| size_estimate | NUMBER(38,0) | Estimated serialized size of the transaction in bytes. |
| error_message | VARCHAR(16777216) | Error message if the transaction failed; null on success. |
| approvals | VARIANT | List of signatures (signer plus signature) authorizing the transaction. |
| header | VARIANT | Transaction header metadata (chain name, timestamp, ttl, etc.). |
| payment | VARIANT | Payment logic with motes amount; populated for legacy Deploy transactions only. |
| payload | VARIANT | Full transaction body (args, target, pricing, initiator); populated for Version1 transactions only. |
| session | VARIANT | Session code or stored contract call; populated for legacy Deploy transactions only. |
| api_version | VARCHAR(16777216) | Node API version that produced the transaction payload. |
| era_id | NUMBER(38,0) | Era (epoch) the block belongs to. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block this event was included in. |
| block_height | NUMBER(38,0) | Height of the block this event was included in. |
| block_hash | VARCHAR(16777216) | Hash of the block this event was included in. |
| operation_count | NUMBER(38,0) | Number of operations recorded for this transaction. |
| transform_count | NUMBER(38,0) | Number of state transforms produced by this transaction. |
| native_transfer_count | NUMBER(38,0) | Number of native CSPR transfers triggered by this transaction. |
| transaction_version | VARCHAR(16777216) | Casper transaction format: Deploy (legacy) or Version1 (Casper 2.0). |
| execution_result_version | VARCHAR(16777216) | Execution result format version (e.g., ExecutionResultV2). |
| _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. |