Table Description

The linea.logs table represents the logs generated by the Ethereum Virtual Machine (EVM) when a contract is executed. Logs are a way to store data on the blockchain. Logs originate from events that occur during the execution of a smart contract. A log consists of:

  • topic list: a list of 0 to 4 32-byte data topics. Topic0 is the hash of the signature of the event (indexed), and the remaining topics are indexed parameters of the event.
  • data: contains non-indexed data.
This is the raw version of this table, for decoded event logs, see the This is the raw version of this table, for decoded event logs, see the decoded logs section.

Column Descriptions

Datatypes on Snowflake datashare are different in some cases, read more here.

Table Sample

Examples

Filter the logs for a specific contract

SELECT *
FROM linea.logs
WHERE contract_address = 0x06012c8cf97bead5deae237070f9587f8e7a266d
LIMIT 10

Filter the logs for a specific topic

SELECT *
FROM linea.logs
WHERE topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef

Show the logs of a specific block

SELECT *
FROM linea.logs
WHERE evt_block_number = 1000000