Table Details
| Property | Value |
|---|---|
| Table Name | hedera.raw.logs |
| Table Status | Beta 🌱 |
| Unique Key | consensus_timestamp, transaction_id, transaction_nonce, log_index |
| Clustering Key(s) | to_date("consensus_timestamp") |
| Search Optimization | transaction_id, block_number, address, topic0 |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| consensus_timestamp | TIMESTAMP_NTZ(9) | The consensus timestamp when the log was generated |
| transaction_id | VARCHAR(16777216) | Unique identifier for the transaction that generated this log |
| transaction_nonce | NUMBER(38,0) | Nonce of the transaction |
| log_index | NUMBER(38,0) | Index of the log within the transaction |
| payer_account_id | VARCHAR(16777216) | Account ID of the account that paid for the transaction |
| address | VARCHAR(16777216) | Contract address that generated the log |
| contract_id | VARCHAR(16777216) | Contract ID that generated the log |
| data | VARCHAR(16777216) | Log data (hex encoded) |
| topic0 | VARCHAR(16777216) | First topic (event signature) |
| topic1 | VARCHAR(16777216) | Second topic (first indexed parameter) |
| topic2 | VARCHAR(16777216) | Third topic (second indexed parameter) |
| topic3 | VARCHAR(16777216) | Fourth topic (third indexed parameter) |
| bloom | VARCHAR(16777216) | Bloom filter for the log |
| consensus_timestamp_raw | NUMBER(29,9) | Raw consensus timestamp as decimal |
| block_number | NUMBER(38,0) | Block number containing this log |
| block_hash | VARCHAR(16777216) | Hash of the block containing this log |
| transaction_index | NUMBER(38,0) | Index of the transaction within the block |
| transaction_result | VARCHAR(16777216) | Result of the transaction |
| extra_evm_fields | VARIANT | Additional EVM-specific fields |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |