Skip to main content
Schema: blast.core Table: fact_event_logs Type: View This table contains flattened event logs from transactions on this EVM blockchain. Transactions may have multiple events, which are denoted by the event index for a transaction hash. Therefore, this table is unique on the combination of transaction hash and event index. Please see fact_decoded_event_logs or ez_decoded_event_logs for the decoded event logs.

​
Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed. This field will not be unique in this table, as a given transaction can include multiple events.
EVENT_INDEXNUMBEREvent number within a transaction.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
TOPICSVARIANTThe un-decoded event input topics.
TOPIC_0TEXTThe first topic of the event, which is a unique identifier for the event.
TOPIC_1TEXTThe second topic of the event, if applicable.
TOPIC_2TEXTThe third topic of the event, if applicable.
TOPIC_3TEXTThe fourth topic of the event, if applicable.
DATATEXTThe un-decoded event data.
EVENT_REMOVEDBOOLEANWhether the event has been removed from the transaction.
ORIGIN_FROM_ADDRESSTEXTThe from address at the transaction level.
ORIGIN_TO_ADDRESSTEXTThe to address at the transaction level.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of the contract call that triggered this transaction.
TX_SUCCEEDEDBOOLEANWhether the transaction was successful, returned as a boolean.
FACT_EVENT_LOGS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was last modified.
TX_STATUSTEXTThis column is being deprecated for standardization purposes. Please update your queries to use the tx_succeeded column instead by March 10, 2025.
_LOG_IDTEXTThis column is being removed for standardization purposes. Please remove or update your queries with CONCAT(tx_hash, '_', event_index) to reconstruct _log_id by March 10, 2025.