Skip to main content
Schema: flow.core_evm Table: ez_decoded_event_logs Type: Base Table

​
What

For information on how to submit a contract for decoding, as well as how ABIs are sourced, please visit here. This model contains decoded event logs for contracts that we have an ABI for. Please note, this table does not include all event logs, only those that we have an ABI for. The decoded_log column is the easiest place to query decoded data. It is a JSON object, where the keys are the names of the event parameters, and the values are the values of the event parameters. You can select from this column using the following sample format, decoded_log:from::string or more generally, decoded_log:<event_param>::datatype. See below for a full sample query. The full_decoded_logs column contains the same information, as well as additional fields such as the datatype of the decoded data. You may need to laterally flatten this column to query the data. Sample query for USDC Transfer events: 
select 
tx_hash,
block_number,
contract_address,
decoded_log:from::string as from_address,
decoded_log:to::string as to_address,
decoded_log:value::integer as value
from ethereum.core.fact_decoded_event_logs
where contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')
and block_number between 16400000 and 16405000
and event_name = 'Transfer'
limit 50```

## Columns

| Column Name | Data Type | Description |
| ----------- | --------- | ----------- |
| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed. |
| TX_POSITION | NUMBER | The position of the transaction within the block. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| CONTRACT_ADDRESS | TEXT | The address of the contract that the event log was emitted from. |
| TOPICS | VARIANT | The un-decoded event input topics. |
| TOPIC_0 | TEXT | The first topic of the event, which is a unique identifier for the event. |
| TOPIC_1 | TEXT | The second topic of the event, if applicable. |
| TOPIC_2 | TEXT | The third topic of the event, if applicable. |
| TOPIC_3 | TEXT | The fourth topic of the event, if applicable. |
| DATA | TEXT | The un-decoded event data. |
| EVENT_REMOVED | BOOLEAN | Whether the event has been removed from the transaction. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address at the transaction level. |
| ORIGIN_TO_ADDRESS | TEXT | The to address at the transaction level. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of the contract call that triggered this transaction. |
| TX_SUCCEEDED | BOOLEAN | Whether the transaction was successful, returned as a boolean. |
| EVENT_NAME | TEXT | The name of the event, as defined in the contract ABI. |
| FULL_DECODED_LOG | VARIANT | The full decoded log, including the event name, the event parameters, and the data type of the event parameters. |
| DECODED_LOG | OBJECT | The flattened decoded log, where the keys are the names of the event parameters, and the values are the values of the event parameters. |
| CONTRACT_NAME | TEXT | The name of the contract, if the contract has a name() function. |
| EZ_DECODED_EVENT_LOGS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp at which the row was last modified. |