Raw
Messages
Table Columns
Unique Key:
| Column Name | Data Type | Description |
|---|---|---|
| consensus_timestamp | TIMESTAMP_NTZ(9) | The consensus timestamp when the message was submitted |
| topic_id | VARCHAR | Unique identifier for the topic |
| sequence_number | BIGINT | Sequence number of the message within the topic |
| payer_account_id | VARCHAR | Account ID of the account that paid for the message submission |
| message_base64 | VARCHAR | Message content encoded in base64 |
| message | VARCHAR | Decoded message content |
| chunk_info | VARIANT | Information about message chunks if the message was split |
| running_hash | VARCHAR | Running hash of all messages in the topic up to this message |
| running_hash_version | BIGINT | Version of the running hash algorithm |
| message_id | VARCHAR | Unique identifier for the message |
| consensus_timestamp_raw | DECIMAL(29,9) | Raw consensus timestamp as decimal |
| block_number | BIGINT | Block number containing this message |
| block_hash | VARCHAR | Hash of the block containing this message |
| transaction_hash | VARCHAR | Hash of the transaction that submitted this message |
| transaction_id | VARCHAR | Unique identifier for the transaction |
| transaction_nonce | BIGINT | Nonce of the transaction |
| transaction_result | VARCHAR | Result of the transaction |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |