Table Details
| Property | Value |
|---|---|
| Table Name | osmosis.raw.transactions |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, hash |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | block_height, hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_height | NUMBER(38,0) | The sequential number of the block in the blockchain. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp when the block was created. |
| block_hash | VARCHAR(16777216) | The hash of the block containing the transaction. |
| hash | VARCHAR(16777216) | The hash of the transaction. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block. |
| code | NUMBER(38,0) | The code returned after the transaction execution (e.g., 0 for success). |
| codespace | VARCHAR(16777216) | The namespace for the error codes. |
| gas_used | VARCHAR(16777216) | The amount of gas used for the transaction. |
| gas_wanted | VARCHAR(16777216) | The amount of gas requested for the transaction. |
| tx_acc_seq | VARCHAR(16777216) | The sequence number of the account used in the transaction. |
| tx_fee_payer | VARCHAR(16777216) | The address of the account paying the transaction fee. |
| tx_fee_raw | VARCHAR(16777216) | The raw fee data for the transaction, containing both amount and denomination. |
| fee_amount | VARCHAR(16777216) | The fee amount for the transaction. |
| fee_denom | VARCHAR(16777216) | The denomination of the fee amount. |
| event_count | NUMBER(38,0) | The number of events associated with the transaction. |
| log | VARCHAR(16777216) | The log of the transaction execution in string format. Use try_parse_json to fetch the log details. |
| info | VARCHAR(16777216) | Additional information about the transaction. |
| tx | VARCHAR(16777216) | The transaction details in a serialized format. |
| data | VARCHAR(16777216) | The data returned from the transaction execution. |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was created. |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was updated. |