aurora.core Table: fact_logs Type: View
This table contains log level data for the Aurora Blockchain. This table can be used to analyze
trends at a log level, for example gas fees vs. total transactions over time. For more information,
please see Aurora scan Resources.
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. |
| ORIGIN_FUNCTION_SIGNATURE | TEXT | The function signature of this transaction. |
| ORIGIN_FROM_ADDRESS | TEXT | The from address at the transaction level. |
| ORIGIN_TO_ADDRESS | TEXT | The to address at the transaction level. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| CONTRACT_ADDRESS | TEXT | The address interacted with for a given event. |
| TOPICS | VARIANT | The un-decoded event input topics. |
| DATA | TEXT | The un-decoded event data. |
| EVENT_REMOVED | BOOLEAN | Whether the event has been removed from the transaction. |
| TX_STATUS | TEXT | Status of the transaction. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | ||
| _LOG_ID | TEXT | This is the primary key for this table. This is a concatenation of the transaction hash and the event index at which the event occurred. |
| FACT_LOGS_ID | TEXT | A uniquely generated identifier assigned by a surrogate key |
| INSERTED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which this record was last modified by an internal process. |