crosschain.olas Table: fact_service_events Type: View
What
This fact-based table contains all emitted events related to registered services and service multisigs within the OLAS protocol. For EVMs, this is accomplished by joining all events where the transaction’sorigin_to_address = multisig_address to showcase the onchain interactions with each service. If a service does not have an associated multisig, it will not be included in this table. Various chain-specific columns may be null, as this table joins together the EVM and SVM.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | Blockchain, Network, or Platform the transaction or event occurs on. |
| BLOCK_NUMBER | NUMBER | The block number at which the transaction is finalized. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction in UTC |
| 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 address that initiates the transaction. If a transaction generates multiple events, all of them will have the same originfromaddress. |
| ORIGIN_TO_ADDRESS | TEXT | The address that receives the transaction. If a transaction generates multiple events, all of them will have the same origintoaddress. |
| CONTRACT_ADDRESS | TEXT | The address of the contract interacted with. |
| EVENT_INDEX | NUMBER | Event number within a transaction. |
| MULTISIG_ADDRESS | TEXT | The address of the multi-signature wallet, typically a GnosisSafe. |
| SERVICE_ID | NUMBER | The unique identifier of the registered Service. |
| TOPIC_0 | TEXT | The non-decoded event input topics. |
| TOPIC_1 | TEXT | The non-decoded event input topics. |
| TOPIC_2 | TEXT | The non-decoded event input topics. |
| TOPIC_3 | TEXT | The non-decoded event input topics. |
| DATA | TEXT | The non-decoded, raw data emitted from an event. |
| SEGMENTED_DATA | ARRAY | The raw emitted event log data, segmented into a variant column for further manual decoding and analysis. |
| FACT_SERVICE_EVENTS_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. |