Raw
Logs
Table Columns
Unique Key:
| Column Name | Data Type | Description |
|---|---|---|
| consensus_timestamp | TIMESTAMP_NTZ(9) | The consensus timestamp when the log was generated |
| transaction_id | VARCHAR | Unique identifier for the transaction that generated this log |
| transaction_nonce | BIGINT | Nonce of the transaction |
| log_index | BIGINT | Index of the log within the transaction |
| payer_account_id | VARCHAR | Account ID of the account that paid for the transaction |
| address | VARCHAR | Contract address that generated the log |
| contract_id | VARCHAR | Contract ID that generated the log |
| data | VARCHAR | Log data (hex encoded) |
| topic0 | VARCHAR | First topic (event signature) |
| topic1 | VARCHAR | Second topic (first indexed parameter) |
| topic2 | VARCHAR | Third topic (second indexed parameter) |
| topic3 | VARCHAR | Fourth topic (third indexed parameter) |
| bloom | VARCHAR | Bloom filter for the log |
| consensus_timestamp_raw | DECIMAL(29,9) | Raw consensus timestamp as decimal |
| block_number | BIGINT | Block number containing this log |
| block_hash | VARCHAR | Hash of the block containing this log |
| transaction_index | BIGINT | Index of the transaction within the block |
| transaction_result | VARCHAR | 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 |