Raw
Transactions
Table Columns
Unique Key: block_height, hash
| Column Name | Data Type | Description |
|---|---|---|
| block_height | BIGINT | The sequential number of the block in the blockchain. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp when the block was created. |
| block_hash | VARCHAR | The hash of the block containing the transaction. |
| hash | VARCHAR | The hash of the transaction. |
| transaction_index | BIGINT | The index of the transaction within the block. |
| code | BIGINT | The code returned after the transaction execution (e.g., 0 for success). |
| codespace | VARCHAR | The namespace for the error codes. |
| gas_used | VARCHAR | The amount of gas used for the transaction. |
| gas_wanted | VARCHAR | The amount of gas requested for the transaction. |
| tx_acc_seq | VARCHAR | The sequence number of the account used in the transaction. |
| tx_fee_payer | VARCHAR | The address of the account paying the transaction fee. |
| tx_fee_raw | VARCHAR | The raw fee data for the transaction, containing both amount and denomination. |
| fee_amount | VARCHAR | The fee amount for the transaction. |
| fee_denom | VARCHAR | The denomination of the fee amount. |
| event_count | BIGINT | The number of events associated with the transaction. |
| log | VARCHAR | The log of the transaction execution in string format. Use try_parse_json to fetch the log details. |
| info | VARCHAR | Additional information about the transaction. |
| tx | VARCHAR | The transaction details in a serialized format. |
| data | VARCHAR | 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. |