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

### Table Details

| Property            | Value                                                |
| ------------------- | ---------------------------------------------------- |
| Table Name          | `stellar_testnet.raw.diagnostic_events`              |
| Table Status        | Beta 🌱                                              |
| Unique Key          | `ledger_close_time`, `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) | The ID of the smart contract that generated this diagnostic event                                                                                                                              |
| topics                         | VARIANT           | Array of topics associated with this diagnostic event                                                                                                                                          |
| data                           | VARIANT           | The diagnostic event data in hexadecimal format                                                                                                                                                |
| event\_type                    | VARCHAR(16777216) | The type of diagnostic event                                                                                                                                                                   |
| in\_successful\_contract\_call | BOOLEAN           | Whether this diagnostic event was generated during a successful contract call                                                                                                                  |
| event\_index                   | NUMBER(38,0)      | The index of this diagnostic event within the transaction                                                                                                                                      |
| extension                      | VARCHAR(16777216) | Extension data for the diagnostic event                                                                                                                                                        |
| ledger\_sequence               | NUMBER(38,0)      | The sequence number of the ledger containing this diagnostic event                                                                                                                             |
| ledger\_close\_time            | TIMESTAMP\_NTZ(9) | The close time of the ledger containing this diagnostic event                                                                                                                                  |
| ledger\_hash                   | VARCHAR(16777216) | The hash of the ledger containing this diagnostic event                                                                                                                                        |
| transaction\_hash              | VARCHAR(16777216) | The hash of the transaction that generated this diagnostic event                                                                                                                               |
| transaction\_index             | NUMBER(38,0)      | The index of the transaction within the ledger                                                                                                                                                 |
| transaction\_result            | VARCHAR(16777216) | The result code of the transaction that generated this diagnostic event                                                                                                                        |
| transaction\_successful        | BOOLEAN           | Whether the transaction that generated this diagnostic event was successful                                                                                                                    |
| unique\_id                     | VARCHAR(16777216) | A unique identifier for this diagnostic event                                                                                                                                                  |
| transaction\_events            | VARIANT           | List of Soroban transaction-scoped events emitted during transaction execution, as JSON. These are events not tied to a specific operation (e.g. fee events, transaction-level state changes). |
| \_created\_at                  | TIMESTAMP\_NTZ(9) | Timestamp when this record was created                                                                                                                                                         |
| \_updated\_at                  | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated                                                                                                                                                    |

### Related Docs

* [Stellar Raw Diagnostic Events](/historical-data/supported-blockchains/other-ecosystems/stellar/raw/diagnostic-events)