> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Diagnostic Events V2

### 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.                           |