Table Details
| Property | Value |
|---|---|
| Table Name | stellar.raw.diagnostic_events_v2 |
| Table Status | Production-Ready |
| Unique Key | unique_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | ledger_sequence, transaction_hash, contract_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| contract_id | VARCHAR(16777216) | Soroban contract that emitted this diagnostic event. |
| topics | VARIANT | Array of the event’s SCVal topics. |
| data | VARIANT | The event’s SCVal payload data. |
| event_type | VARCHAR(16777216) | Type of the diagnostic event. |
| in_successful_contract_call | BOOLEAN | True if this diagnostic event was emitted inside a successfully-executed Soroban contract call. |
| event_index | NUMBER(38,0) | Index of this event within its transaction. |
| extension | VARCHAR(16777216) | XDR extension data on this event, used for forward-compatible changes. |
| ledger_sequence | NUMBER(38,0) | Sequence number of the ledger containing this event. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Time when the ledger containing this event closed and was finalized. |
| ledger_hash | VARCHAR(16777216) | Hash of the ledger containing this event. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that emitted this event. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| transaction_result | VARCHAR(16777216) | Result code of the transaction that emitted this event. |
| transaction_successful | BOOLEAN | True if the transaction that emitted this event executed successfully. |
| unique_id | VARCHAR(16777216) | Deterministic unique identifier for this row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| transaction_events | VARIANT | Array of token-transfer and SEP-41 events emitted in the transaction. |