Skip to main content

Table Details

PropertyValue
Table Nameholesky.raw.logs
Table StatusBeta 🌱; Deprecated ◽
Unique Keytransaction_hash, log_index
Clustering Key(s)to_date("block_timestamp")
Search Optimizationtransaction_hash, block_number, topic0, address

Table Columns

Column NameData TypeDescription
log_indexNUMBER(38,0)The position of this log in the block that it belongs to. The first log has index 0.
transaction_hashVARCHAR(66)Unique identifier of the transaction that this log belongs to.
transaction_indexNUMBER(38,0)The position of this transaction in the block that it belongs to. The first transaction has index 0.
addressVARCHAR(42)The address of the contract that emitted this log.
dataVARCHAR(16777216)Unindexed data containing further information of the event, encoded in hex.
topic0VARCHAR(66)The keccak256 hash of a flattened event signature string.
topic1VARCHAR(66)First indexed topic of the event.
topic2VARCHAR(66)Second indexed topic of the event.
topic3VARCHAR(66)Third indexed topic of the event.
block_timestampTIMESTAMP_NTZ(9)The time when the block that contains this log was included on the blockchain.
block_numberNUMBER(38,0)The length of the chain, in blocks.
block_hashVARCHAR(66)Unique identifier of the block that includes this log.
_created_atTIMESTAMP_NTZ(9)Timestamp of the entry creation.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the entry update.
from_addressVARCHAR(42)The address of the sending party of this transaction.
to_addressVARCHAR(42)The address of the receiving party of this transaction, typically a contract address for logs.