Raw
Logs
Logs (or event logs), is a way for smart contracts to communicate with the outside world by “documenting” small pieces of information.
Event logs allow other people to know that something has happened without them having to query the contract directly.
Table Columns
Unique Key: transaction_hash, log_index
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | The address of the contract that emitted this log. |
| data | VARCHAR | Unindexed data containing further information of the event, encoded in hex. |
| topic0 | VARCHAR | The keccak256 hash of a flattened event signature string. |
| topic1 | VARCHAR | First indexed topic of the event. |
| topic2 | VARCHAR | Second indexed topic of the event. |
| topic3 | VARCHAR | Third indexed topic of the event. |
| log_index | BIGINT | The position of this log in the block that it belongs to. The first log has index 0. |
| transaction_hash | VARCHAR | Unique identifier of the transaction that this log belongs to. |
| transaction_index | BIGINT | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| from_address | VARCHAR | The address of the sending party of this transaction. |
| to_address | VARCHAR | The address of the receiving party of this transaction, typically a contract address for logs. |
| block_number | BIGINT | The length of the chain, in blocks. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this log was included on the blockchain. |
| block_hash | VARCHAR | Unique identifier of the block that includes this log. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |