Table Details
| Property | Value |
|---|---|
| Table Name | starknet.raw.messages |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, transaction_hash, message_index, message_source |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | contract_address, from_address, to_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| contract_address | VARCHAR(16777216) | The address of the contract that sent or received this message. |
| entry_point_selector | VARCHAR(16777216) | The selector of the entry point function associated with this message. |
| from_address | VARCHAR(16777216) | The address that sent this message. |
| to_address | VARCHAR(16777216) | The address that received this message. |
| message_hash | VARCHAR(16777216) | Unique hash identifier for this message. |
| message_index | NUMBER(38,0) | The position of this message within the transaction that sent it. |
| message_source | VARCHAR(16777216) | The source of the message (e.g., ‘L1’, ‘L2’). |
| nonce | NUMBER(38,0) | The nonce associated with this message for ordering and uniqueness. |
| payload | VARIANT | The data payload of the message. |
| type | VARCHAR(16777216) | The type of message (e.g., ‘L1_TO_L2’, ‘L2_TO_L1’). |
| execution_status | VARCHAR(16777216) | The execution status of the message (e.g., ‘SUCCEEDED’, ‘REVERTED’). |
| finality_status | VARCHAR(16777216) | The finality status of the message (e.g., ‘ACCEPTED_ON_L1’, ‘ACCEPTED_ON_L2’). |
| version | NUMBER(38,0) | The version of the message format. |
| block_number | NUMBER(38,0) | The block number where this message was processed. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block where this message was processed. |
| block_hash | VARCHAR(16777216) | The hash of the block where this message was processed. |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction that sent this message. |
| transaction_index | NUMBER(38,0) | The index of the transaction within its block. |
| unique_id | VARCHAR(16777216) | Unique identifier for this message |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated. |